Need help with search dates!!!

[Antonio Pitt]

I have created a form whereby the user can search for records by date using a drop-down list containing the values stored in my table.
However, the search is only returning records entered on some dates and not others although the records clearly exist in my table.

This is the VBA code used:

stDocName = "frm_Search Results Date"
stLinkCriteria = "[Date]=" & "#" & Me![Combo24] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Any help would be greatly appreciated.

 

[Rich]

You need to rename the field Date for starters, it's a reserved word in access.