How to create dynamic search forms?

[aabaaiaaa]

Hiya guys, I need to create a form that works exactly in the same way as a query works, so there's a criteria text box on the top of the form and a list box displaying all results. I know a query does this but i need a user friendly way of displaying this information.

The search is for customer names and i need to display this information in a user friendly way because my users will need to search the database before deciding whether the customer has been inputted into it or not.

I tried to create this using a query having the criteria as the form's text box value (as an expression) but when I input values into the text box the query does not update unless i reopen the query in edit mode and perform a search manually.

My email is aabaaiaaa@gmail.com if any of you guys have any ideas! Thanks

Jay x

 

[austinr]

I have been doing something similar. I found the following post to be very helpful:http://www.access-programmers.co.uk/forums/showthread.php?t=99353&highlight=search

 

[KeithG]

you need to build your SQL statement dynamically.

 

[aabaaiaaa]

Thanks guys! With your help I have managed to rig it to work for me. I'm a very happy chappy!

Jay