Originally Posted by gemma-the-husky
you are better to base the form on a dynaset, but set enableedits to false
then you cant edit anything
but you can change enableedits to true in code
me.enableedits = true, which "unlocks" the form.
I have a searchbox to retrieve the correct record at the header of the form. If i set enableedits to false, the user cannot use the searchbox to retrieve the record.
The original intention of this form is just for viewing only. The user only require to key in the id number and hit enter, the rest of the controls fills up with the information but these information should not be editable to prevent "accidents" from happening.
I was thinking of first setting the enableedit to false, and when the mouse moves over the search button, set me.enableedits = true. And then when the mouse moves off the search button, set me.enableedits = false.
Is there a mouse off event or alternative event?