Search request

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

Guest

I am designing a database which needs a <find> form on it.
I am using a query to select the records that I need from a table, but my
search criteria comes from a form. The search will be performed using all
five fields on the form. The query will either try to match the value in the
field (if there is a value), or else return all records for that field (the
search will then be narrowed down by the other fields.
 
Don't worry guys, I worked out that I could do it with:
Like "*" Or Forms![FormFind]!Field
 
Sorry, but it didn't work like I had hoped. When there is a value in the
field, it works fine, but when there isn't, it doesn't show any records. The
actual code that I am using is this:
IIf([Forms]![FormFind]![width]=Null,Like "*",[Forms]![FormFind]![width])
Also, can you please tell me how to go from my search form, to the query,
and use this to open another form, showing only the selected records?
Thank you very much

a_m0d said:
Don't worry guys, I worked out that I could do it with:
Like "*" Or Forms![FormFind]!Field

a_m0d said:
I am designing a database which needs a <find> form on it.
I am using a query to select the records that I need from a table, but my
search criteria comes from a form. The search will be performed using all
five fields on the form. The query will either try to match the value in the
field (if there is a value), or else return all records for that field (the
search will then be narrowed down by the other fields.
Click to expand...
Click to expand...
 
Back
Top