try a different format for date range: mm/dd/yyyy
you don't have to view it that way, but a query may need it that way.
Look at the DLookup() syntax again. You are missing the criteria field name.
Try something like:
where WriteOffDate169 is a field in the domain (which can be a query)Code:MntNum169: DLookUp("MntID038","q01Month", "WriteOffDate169 Between #" & FstDayOfMnth038 & "# And #" & LstDayOfMnth038 & "#")
Thank you. Its asking for parameter value on FstDayOfMnth038 and LstDayOfMnth038. WriteOffDate169 is local. Other two are foreign.
Maybe you could make a demo dB with just the table, form and query?