Here's our Microsoft Office Tip for.. June 23, 2003
Click Here to see a complete list of all of our previously released Tips!
Access data is easily available, which means it's also easily deleted or corrupted. If you use forms to display data, you may not want users also to be able to change that data. If this is the case, open the form in Design View and set its AllowEdits property to No. You can also set this property programmatically using the Open Form method in the form
DoCmd.OpenForm "frmReadOnly", acNormal, , , acReadOnly
The acReadOnly constant opens the form in read-only mode.