Charlie,
I had a similar question. It was:
I want to create an inquiry screen where the user can enter a person name in
a combo box, which is bound to the member name in the table.
I already have a data entry form. Ideally, I would like to have my data
entry form do double duty as both a data entry form and an inquiry form. If
I change the form's Allow Edits to NO, then I can not enter the member's name
in the combo box. I know I can set each field's lock property to "YES", but
my concern is if I add a new field I will forget to Lock it if the program is
run in display mode. (I pass the run type - Input or Display - in the Open
Args).
Is there a simple way to Lock all fields except my name combo box or am I
better off create a different form that only display data?
Jeanette Cunningham from Melbourne, Australia was kind enough to let me in
on this little trick:
One way round this dilema is to only set allow edits to true when the user
enters the combo used to find a member - use the Enter event. After user has
made their selection and is leaving the combo, use the Exit event of the
combo to set allow edits to false.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
