A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Gray out" subform



 
 
Thread Tools Display Modes
  #1  
Old October 25th, 2005, 08:18 PM
Tracey
external usenet poster
 
Posts: n/a
Default "Gray out" subform

Using MS 2003, I have a form with a subform. Based on checking a field on the
master form, I would like the subform to become inaccessible (ie. grayed
out), but I don't want the subform to become invisible. Is there a way to
make the entire subform inaccessible, but visible without making each
separate field in the subform inaccessible individually?
  #2  
Old October 25th, 2005, 09:38 PM
Ofer
external usenet poster
 
Posts: n/a
Default "Gray out" subform

Try
Me.[SubFromControlName].Enabled = False

Or
Me.[SubFromControlName].Locked = True
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



"Tracey" wrote:

Using MS 2003, I have a form with a subform. Based on checking a field on the
master form, I would like the subform to become inaccessible (ie. grayed
out), but I don't want the subform to become invisible. Is there a way to
make the entire subform inaccessible, but visible without making each
separate field in the subform inaccessible individually?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
unlinked subform Don Barton Database Design 5 May 20th, 2005 12:23 AM
Subform on Subform problem JohnB Using Forms 4 April 10th, 2005 12:52 PM
Form Subform data export [email protected] Using Forms 6 January 6th, 2005 06:25 PM
Subform Refresh Problem (but only with an unbound combo box control) Barry Skidmore Using Forms 1 December 21st, 2004 01:19 AM
dealing with a subform record when it's "dirty" Paul James Using Forms 8 October 17th, 2004 08:45 AM


All times are GMT +1. The time now is 05:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.