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
 
Top