lose Subforms when Main Form read-only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thanks Allen I will give that a try!

Allen Browne said:
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.
Click to expand...
 
Back
Top