Search Question

[stevan]

I hae a lot of customer in my Service Call Management Database . I am using the find button on the last name . Is there someother way to see if a customer exists? Using the find button you have to click on the last name then bring up find . Any other way to make it easier??

THXS Steve

 

[wazz]

create an unbound, popup search form (frmSearch). on it you could:

- put a combo box that lists all of your customers; afterupdate, go to the selected customer;
- put a listbox that lists all customers; onclick or ondoubleclick, go to the selected customer;
- put unbound text boxes wherein you can enter an ID, or a FName or a LName; add a search button.

 

[stevan]

DO I start with a table, form or querie . Then I quess you can you a wizard to make the whole thing work


STEVE

 

[wazz]

start with a query of all of your customers, including PK, lastname, first name.

start a new blank form. put a list box on it. for the list box's Row Source use the query you just made.

start with that.