Create inquiry screen where users can enter name look-up info

[Dennis]

Hi,

I'm on Access 2003 via XP Office on Xp Pro with SP3.

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?

After doing a little bit more research, I realize that the only way to
create a inquiry only screen is to lock all of the data entry fields. Is
this correct, or am I missing something.

 

[Jeanette Cunningham]

Hi Dennis,
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

 

[Dennis]

Jeanette,

Thank you very much! It worked great and it will save me SO MUCH WORK in
the future!

I knew there was a simple solution.

By the way, you live in a wonderful city. I was lucky enough to spend about
a week there. A little cold for my taste (I live in Cocoa Beach, Florida -
near Cape Canaveral - Space Shuttle home) but a wonderful city. The
neighborhoods reminded me of the neighborhoods in San Francisco, Ca where I
grew up.

Have a wonderful day and thank you for your help.

Dennis

 

[Jeanette Cunningham]

You're very welcome.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia