text box filters date or no filter if blank

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

Guest

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.
 
Try

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