Setting a lookup for a table

[JohnM]

I have a table with 150 names address's etc what I need is
to have a query? that will enable me to search the database
for a particular name or other variables as I set them up
and place it on the main switchboard so people can lookup a
certain person or group of people.
Thanks

 

[fredg]

I have a table with 150 names address's etc what I need is
to have a query? that will enable me to search the database
for a particular name or other variables as I set them up
and place it on the main switchboard so people can lookup a
certain person or group of people.
Thanks

If I understand you correctly, create a form (or use a current form)
that will actually display the record after it is found.
Add an unbound combo box to the form header.
Use the command button wizard to set it up for you.
Select the 3rd option on the first page of instructions, something
like 'Find a record ... etc. '

When completed, enter the name in the combo box and that person's
record will be displayed in the form.

 

[John M]

Great work Thanks very much