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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
"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 | |
|
|
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 |