By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,589 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

Access 2K - Read-Only Forms

P: n/a
Have a f-end/b-end database, with three forms that are dual-purpose...

If the user clicks one button on the Main Menu, then the form opens
allowing edits; if the user clicks another button on the Main Menu,
the form (should!) open Read-Only - only it doesn't...

Of the forms that should behave in this way, two of the three operate
fine - preventing changes to any of the controls - the other one just
doesn't want to be locked down. Here's what I've tried:

1. Changing "AllowEdits" via VB, both from Form_Open and Form_Current
2. Changing "AllowEdits" in form design

Both of these methods had the same result - the third form could still
be edited.

Having looked through the discussion threads, the only thing I haven't
tried is locking all the controls on the form - but this seems a bit
excessive.

Any thoughts would be appreciated (to stop me losing my mind!)

Cheers,

PTurn
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
For your 3rd form, you have some code that is dirtying the record, probably
in Form_Current.

Wisely, Microsoft allows you to continue your edit and save the change if
the form is dirty, even if AllowEdits is set to No, so you are not stuck in
the situation where you cannot complete the entry.

--
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.

"pturn" <pt***@talk21.com> wrote in message
news:85**************************@posting.google.c om...
Have a f-end/b-end database, with three forms that are dual-purpose...

If the user clicks one button on the Main Menu, then the form opens
allowing edits; if the user clicks another button on the Main Menu,
the form (should!) open Read-Only - only it doesn't...

Of the forms that should behave in this way, two of the three operate
fine - preventing changes to any of the controls - the other one just
doesn't want to be locked down. Here's what I've tried:

1. Changing "AllowEdits" via VB, both from Form_Open and Form_Current
2. Changing "AllowEdits" in form design

Both of these methods had the same result - the third form could still
be edited.

Having looked through the discussion threads, the only thing I haven't
tried is locking all the controls on the form - but this seems a bit
excessive.

Any thoughts would be appreciated (to stop me losing my mind!)

Cheers,

PTurn

Nov 13 '05 #2

P: n/a

Allen,

Many thanks for that... It turned out that I was modifying some hidden
controls, and even though they were unbound it was still causing the
AllowEdits failure.

You've saved my day from being totally wasted!

PTurn
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.