Need help with search dates!!!

Antonio Pitt

New member
Local time
Today, 06:04
Joined
Oct 15, 2001
Messages
6
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.
 
You need to rename the field Date for starters, it's a reserved word in access.
 

Users who are viewing this thread

Back
Top Bottom