Delete query based on dates 1

[NWTrust]

I have a delete query which has a field "Date Purchased". On my form frmDeleteByDate I have a box "Date" formatted as Medium Date.
In the query in the "Date Purchased" column I have <[forms]![frmDeleteByDate]![Date] the object being to delete all records with a date less than the date entered.
If I run the query direct and enter a date when requested the required records are deleted but if I enter the required date into frmDeleteByDate and call the query all records are deleted.
Any help would be greatly appreciated.

NWTrust

 

[Golom]

Can you post the query that you are running?

I would expect that it is something like

DELETE * FROM SomeTable

WHERE [Date Purchased] < [forms]![frmDeleteByDate]![Date]

 

[NWTrust]

Thanks, Golom. You are correct regarding the query but I'm afraid a closer look revealed a typing error. On correcting this the query now works fine.