Read Only Form - Take 3

[Louise]

Sorry to be a pain!!

Thanks again for the suggestions.

By changing the recordset to Snapshot though the information in the form can't be updated by the requeries as I scroll through the records.

And I tried opening the form with code as acReadOnly but that doesn't seem to make a difference. The data can still be changed.

Any other ideas? I've pretty much exhausted everything I could think of.

 

[Carol]

If you want the information within a form to be locked, make every text field with their Enable Field set to 'No' and their Locked Field set to 'Yes'. Leave the combo box to enabled and not locked. Hope this is the information that you want.
Good Luck

 

[Travis]

Just set the AllowEdits, AllowAdditions and AllowDelete properties of the form to False.