I want to develop a form for the users to be able to search on either a license number or by name. Currently, I am thinking of 2 seperate text boxes (1 each) and when the user fills in then leaves the box, it triggers an event to search.
There are several tables (Name and address info on one, License info on a second) that are joined by the NameID.
(This is in Access 2000)
What sort of approach should I go? I would like to try VB and ADO, but I am open to whatever can work.
Thanks