I'd like to prevent users from accidently going into design view of a form
and screwing it up.
I've googled the group and have found that the normal method is to use MDE
or user level security. I'd like to avoid both of those options as I'm only
trying to stop accidental changes, not willful misconduct. These mdb's are
too quick/simple to over program.
Now, I have found that the following code works, but I'd like to get your
opinions.
Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
DoCmd.Close
On Error GoTo 0
End Sub
I understand that if the user gets the database window, they can open the
form in design view. That's fine, I'll can live with that. I just want code
such that if they are changing from datasheet view to form view or back; and
they accidently click on the "green triangle", the form will just close
instead of opening in design view.
Any forseeable problems with this?
TIA
Fred Zuckerman