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
|
|||
|
|||
lose Subforms when Main Form read-only
Hi,
I have set up a form that has a series of related sub-forms on Tab controls (it's a Contact management database, so the subforms/tabs contain information on Membership type, Publications, each contact event with the individual, and so on). I'd like the forms to be Read Only until the user specifically chooses to edit a record, to prevent accidental changes. I tried doing this by setting AllowEdits=False on the main form and then creating buttons that update to AllowEdits=True. When I set the main form edits to false, though, all of the subforms disappear from the tab controls. It's not that they are locked - they are simply not there. Any suggestions? Oh, I am using Access 2000. |
#2
|
|||
|
|||
lose Subforms when Main Form read-only
For an explanation of why your subforms disappear, see:
Why does my form go completely blank? at: http://allenbrowne.com/casu-20.html For an alternative way of locking the data in your form and subforms, see: Locking bound controls on a form and subforms at: http://allenbrowne.com/ser-56.html You don't need to change any of the code in that article. Just follow the steps to set it up in your form. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Kate M" wrote in message ... I have set up a form that has a series of related sub-forms on Tab controls (it's a Contact management database, so the subforms/tabs contain information on Membership type, Publications, each contact event with the individual, and so on). I'd like the forms to be Read Only until the user specifically chooses to edit a record, to prevent accidental changes. I tried doing this by setting AllowEdits=False on the main form and then creating buttons that update to AllowEdits=True. When I set the main form edits to false, though, all of the subforms disappear from the tab controls. It's not that they are locked - they are simply not there. Any suggestions? Oh, I am using Access 2000. |
#3
|
|||
|
|||
lose Subforms when Main Form read-only
Thanks Allen I will give that a try!
"Allen Browne" wrote: For an explanation of why your subforms disappear, see: Why does my form go completely blank? at: http://allenbrowne.com/casu-20.html For an alternative way of locking the data in your form and subforms, see: Locking bound controls on a form and subforms at: http://allenbrowne.com/ser-56.html You don't need to change any of the code in that article. Just follow the steps to set it up in your form. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Kate M" wrote in message ... I have set up a form that has a series of related sub-forms on Tab controls (it's a Contact management database, so the subforms/tabs contain information on Membership type, Publications, each contact event with the individual, and so on). I'd like the forms to be Read Only until the user specifically chooses to edit a record, to prevent accidental changes. I tried doing this by setting AllowEdits=False on the main form and then creating buttons that update to AllowEdits=True. When I set the main form edits to false, though, all of the subforms disappear from the tab controls. It's not that they are locked - they are simply not there. Any suggestions? Oh, I am using Access 2000. |
Thread Tools | |
Display Modes | |
|
|