date not displaying after changing recordsource

[liddlem]

Hi All
If I look at ALL my records (IE: the forms recordsource as per the underlying query) then the date is displayed correctly.
However, If I want to filter records (by changing the recordsource as I cannot use a filter in this case.) then the date displays as #Name?

The field is a datetime on the SQL server.
I have tried setting the format on both the form and the linked table in access, but this makes no difference to how its displayed after the recordsource is changed.

I'm using Access2016 (Front End) and SQL2016 (Back End)
What is going on here? How do I fix it?

 

[JHB]

I suppose Date is a field name in a table, so do you include that field in the recordsource when you change it?
You shouldn't use Date as field name, because it is a reserved words in ms access.

 

[liddlem]

Ahh - sorry all
It turns out that the data in the new (updated) recordsource query did not include the date field.
DUH!