help please!

[need help please]

Im looking for a way that i could make something like the query builder in a forum. I need drop down boxes that list all the fields in the database and a text box to put a value in. The problem that i keep running into is that if one box doesn't have a value in it i get nothing returned.

Is there a easier way to do this

Thanks!

 

[Bob Sullivan]

Hello

You need to change the criteria in your query to something like this

Like "*"&forms![myform]![myInputField

The like property with the wildcard will allow your query to ignore blank values in the form when processing the query

Bob Sulliva
----- need help please wrote: ----

Im looking for a way that i could make something like the query builder in a forum. I need drop down boxes that list all the fields in the database and a text box to put a value in. The problem that i keep running into is that if one box doesn't have a value in it i get nothing returned.

Is there a easier way to do this

Thanks!

 

[CrazyITGuy]

negative.. it comes back with

Like "*" &[forms]![myform][myInputField

It isn't liking the "&forms" :

thx again

 

[StCyrM]

Hi

Leave a space between the & and [forms]
Like "*" & [forms]![myform][myInputField]

This has been working since the beginning of time !!!!!

Maurice