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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Parameters query 1
Can I save a sql statement generated by a search form? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
QBF & Query Malfunction 0
Criteria to return all records if selection from form is null 4
How To Specify No Criteria 2

Top