Search Criteria (1 Viewer)

[Avaughan]

I am programing a form to be used to input search criteria on a table. I have several variables that will filter throught the table and only provide registers that fulfill with the search crieria. Can someone offer code that will sift through the null values. In the search screen, the user does not have to enter all variables.

Setting searchcriteria equal to the variables doesn't work because of the nulls.

Thanks
Andrew

 

[raindrop3]

Hello,

can you fill in a '*' for the variables that aren't fill in? If the user want to search for 2 of the 5 criteria, you can fill the empty searchfields (automatically) with a '*'.

Greetings,

Albert

[This message has been edited by raindrop3 (edited 01-07-2002).]