Rookie question about Access 2003

[Ron Geilow]

I just starting to use Access 2003 and will try to create some applications
for our office. I would like to know what the best way would be to open a
table using a switchboard button where it prompts a user for which field they
would want to look in and the value that they would like to search for in
order to find a particular record in the table. Then hit a button and the
information for that particular record is displayed.

 

[KARL DEWEY]

No, you should use a form to interface with a table and then that is best to
have a query between the table and form.

 

[Christy Wyatt]

You'll want to create a form, and then use your toolbox to add a combobox.
Have the wizard (magic wand icon) click on the combobox button and put it on
your form. The wizard will start, and one of your choices will be to look
for a certain record based on what is chosen in that combobox. You'll
populate the combobox with a lookup table, or a query based on another table,
such as customer, employee, etc.