Opening a Read Only Form

[SQLSister]

DoCmd.OpenForm "frmProposalTools", , , , acFormReadOnly

Has anyone ever run into an instance where the form was still editable after opening it with this command? If so, can you tell me why?

Questions about posting. See faq183-874

 

[PHV]

Are you sure all the following are set to false ?
AllowEdits, AllowDeletions, AllowAdditions

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

If you toggle some of the form properties programatically in some events (open, load, current?) you might loose that setting. Thinking about .AllowEdits, .AllowAdditions

Roy-Vidar

 

[SQLSister]

Interestingly I did not toggle .allow edits in the OnCurrent event but because it was performing an update to several field values it toggled it underneath. Luckily it turned out to be old code that was no longer needed after revising the underlying query earlier, so I could just take it out. Otherwise I guess I would have had to save the record and then set the form to not allow edits, additions and deletes.

Thanks for the answer guys, I appreciate it.

Questions about posting. See faq183-874