Search Help

[jimd1768]

I know this will be very basic but i need help. I have a table of customers. I have set up auto form with the table.
I would like to have a form that allows me to search for a customer.
example:

Enter Customers Surname__________

An this returns customers with this surname.

All help is appreciated
Thanks in advance

 

[Dennisk]

use the combo box wizard. One of the options is the find a record based on the criteria you have entered.

ensure that the Primary key of the customer is in the first column and set the column width to 0. The next column would be customer name. Sort this ascending.

 

[jimd1768]

Thank you very much