I have an entry form, which is opened in add mode, an edit form, which is in edit mode. Then I have a search form and a report form, both of which are in edit mode.
I've discovered a problem with my the search and report forms, where data in the table can be changed inadvertantly.
On both of those forms I have comboboxes that are populated and autocompleting from a query for the appropriate fields, and then search buttons below them. But if someone were to begin to enter something, and then backspace, it will edit the data in the table. Ive tried to change the allow value list edits to no, and that does not work. Ive tried enabling locked, which from the tooltip of preventing changes to the data in form view is exactly what I want. But when I do that, I become unable to type anything into the combobox at all.
Is there some other way to open a form from a switchboard, a read only mode, if you will? Or is there a different way of preventing data from being changed at all on those two forms which were opened in edit mode?