Below is the SQL code of a query that is the row source of a combo box on a subform (frmOrderDetailEntry) of a form (frmOrderHeaderEntry). The data is pulling correctly for all textboxes that contain alphanumeric data, but it is not for the textbox (OrdRecdDateTxt) that contains a date. It shows NULL in the query even though there is a valid date in the textbox. I have verified (repeatedly) that the spelling of the form and textbox are correct. Can someone help me pinpoint what is wrong in either my query or my form that might cause this error?
Thanks.
Code:
SELECT CustNumber, BBIItemNumber, PlanogramCode, PriceBeginningDate, PriceEndingDate, SpecialPrice
FROM tblSalesSpecialPricing
WHERE (((CustNumber)=[forms]![frmOrderHeaderEntry]![CustNumberTxt]) AND ((BBIItemNumber)=[BBItemNumberCombo]) AND ((PlanogramCode) Is Not Null) AND ((PriceBeginningDate)<=[forms]![frmOrderHeaderEntry]![OrdRecdDateTxt]));