Basically i've created a database, it has 5 tables -
Customers
Products
Staff
Suppliers
Link table

Need help with creating a search function, this needs to be created for the customers, products, and staff..
Basically i would like it so you enter a name into a text box or something and then the search results display beneath...

Can anyone give me help on how to do this? Thanks

why not use edit/find, (the binoculars icon)

because i need a search form for the database for a business.. i don't think i can do what i want to do with that option.

i need help with the vb code to put in so that when a forename or surname or whatever is input then the search results come out maybe in a subform at the bottom.

Have a look at this sample file: http://allenbrowne.com/ser-62.html

JR

yeaa that's perfect thank you!
so i make it as a form not a query or anything?