search form???

[redblaze]

hi, i am adding a search form to my database. i need to be able to search for a customer--by ID or by surname, and also search for the invoice....again by invoice ID, or Customer ID.

the thing is i have no idea on how to go about making the form, to make it as easy to use a possible, minimising the complexity of it. is anyone able to give me some tips on the layout, what to include and what not to include for the form??

thanks in advance!

 

[Jack Cowley]

I expect that you will be searching two different tables so you can either use two distinct forms with 2 combo boxes each or one form with 3 combo boxes. I am going to suggest you look at the article below as the method of quering your data. It may look a bit intimidating but is the method I would suggest as it is easy to add more search items if you like.

The Combo boxes should have the CustomerID's, Customer Surnames and InvoiceID's. Pretty straight forward... Now just look at the article and have a blast....

Query by form

hth,
Jack