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