text box filters date or no filter if blank

B

bicyclops

How can I modify this part of my query's where statement:

((TblAssyShipments.DateDueSubQty) > (Forms!FrmAssyStatus2!TxtOldest))

to work so that no filter will be applied when the text box TxtOldest is
blank?
I've used similar statements for combo boxes such as:

Like Forms!FrmAssyStatus2!CboOrderID & "*"

but that method doesn't seem to apply here.
 
O

Ofer Cohen

Try

Where TblAssyShipments.DateDueSubQty > Forms!FrmAssyStatus2!TxtOldest Or
Forms!FrmAssyStatus2!TxtOldest Is Null
 

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

combo box selection returning too many records 1
Query using text from form or anything if empty 2
Is It Possible To Disable Combo Box on Parameter Query Form 4
Using 3 criteria to filter a report????? 2
Linking Check Boxes or List Box to Query 0
Parameter Criteria from a forms Text box - 2003 - not working 5
use query Criteria from combo box to set subform Filter 1
Filter from Form 6

Top