Rookie question about Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron Geilow - 18 May 2007 22:39 GMT

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.

Reply to this Message

KARL DEWEY - 18 May 2007 22:48 GMT

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.

Signature

KARL DEWEY
Build a little - Test a little

> 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.

Reply to this Message

Christy Wyatt - 21 May 2007 14:30 GMT

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.

Signature

Christy Wyatt

Reply to this Message