multiple run-time query

[jgeneie]

hi all,
I have a major problem here...

I have created a very simple table to store customer profiles ( eg. customer name, country, tele, address )

Question: I need to create a form that can do run-time query.
I create a few text boxes to key in my search criteria
eg. i have a textbox for country and customer name, so when i key in "singapore" and "customer name", i have a whole list of the "customer name" that come from "singapore".

how do i do it? can i dont use vb to do it?
please advice

 

[jobo123]

Hi jgeneie,

I wonder if you are looking for a run-time filter by form? Filter by form is not available in Run-time Access97 (not sure about later versions of Access). There is however a Run-time filter by form method available from the Microsoft Download Centre:

FAQ No: Q166634

It is a bit on the hard side (I found it so anyway). What is does it grab the entries made to the form when inputting criteria and then consruct a valid SQL statement in visual basic. You might not find it appropriate for your needs but it should at least be good food for thought.
All the best jobo123.