Query Bound to Form returns no records (1 Viewer)

[hokiewalrus]

I have a query that if run alone, returns the records I would expect.

However, when I bind a form to that query, I get no records returned no matter what I do. Is there any reason this would happen? My other forms bound to different queries work as expected.

The query (the hardcoded date is for testing only):

SELECT TableEmployee.PayrollNumber, TableEmployee.LastName, QueryCollectedPayrollWeek.PayrollStatus, QueryCollectedPayrollWeek.WeekEndDate
FROM TableEmployee LEFT JOIN QueryCollectedPayrollWeek ON TableEmployee.PayrollNumber = QueryCollectedPayrollWeek.PayrollNumber
WHERE (((QueryCollectedPayrollWeek.WeekEndDate)=#1/13/2010#))
ORDER BY TableEmployee.PayrollNumber;

I've also attached a screenshot of the properties of the form, if that is worth anything.

I'm sure I'm missing something easy here, but I'm at a loss.

 

[MarkK]

You have the DataEntry property of the form set to Yes. When the form opens it immediately navigates to a new record. Set this property to No and see if your records appear.

 

[hokiewalrus]

Yes, of course! Thank you, that did the trick.

Amazing that one can stare at that for 45 minutes and never actually "see" what the problem is.

 

[MarkK]

Wow, only 45 minutes? You got off easy!
Cheers,