Form bound to a query does not return the correect records.

M

Michel

Dear all,

The situation is as follows: I have a query for which the criteria come from
a form which the users of the DB can fill in. I have linked the form to the
Query by using citeria like: [Forms]![Form1]![Text24] in the query.

This works out perfectly when you fill in criteria in this field on the
form. However when nothing is filled on the form I want the query to return
ALL records, whereas leaving the criteria on the form empty now will only
return null values for that specific field.

I have tried trying citeria like: Like [Forms]![Form1]![Text24] & "*"
however this did not give the desired result.

Can anyone help me out on this one?

Thanks in advance!!

Regards,

Michel
 
Top