help please!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
 
negative.. it comes back with

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

It isn't liking the "&forms" :

thx again
 
Hi

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

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

Maurice
 
Back
Top