Searchable text box

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I have a Access database containing one table with 3
columns. The columns are product id, product name, product
description. I would like to create a searchable text box
in a form where the user types in the product id and the
information is displayed in another text box. Is this
possible and if can you describe in detail in how to
accomplish this.
 
I have a Access database containing one table with 3
columns. The columns are product id, product name, product
description. I would like to create a searchable text box
in a form where the user types in the product id and the
information is displayed in another text box. Is this
possible and if can you describe in detail in how to
accomplish this.
Click to expand...

It's builtin and very simple.

Create a Form based on the table. Include the product name and
description fields (and the ID if users in fact know and use the ID
value; if it's an autonumber provided by Access, it's better to leave
it concealed).

Use the Combo Box tool from the Toolbox, with the magic wand icon
selected.

Choose the option "Use this combo box to find a record".


John W. Vinson[MVP]
 
Back
Top