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  

lose Subforms when Main Form read-only



 
 
Thread Tools Display Modes
  #1  
Old December 12th, 2006, 02:41 AM posted to microsoft.public.access.forms
Kate M
external usenet poster
 
Posts: 2
Default 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  
Old December 12th, 2006, 03:14 AM posted to microsoft.public.access.forms
Allen Browne
external usenet poster
 
Posts: 11,706
Default 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  
Old December 31st, 2006, 10:12 PM posted to microsoft.public.access.forms
Kate M
external usenet poster
 
Posts: 2
Default 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

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


All times are GMT +1. The time now is 07:24 AM.


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