I have a table in Access 97 with [BillDate] a Date/Time type field
Formated "Short Date", UK local settings (dd/mm/yy).
Want to go to a record with a date selected from a combo (correctly
Short Date formatted) on a form.
Me.RecordsetClone.FindFirst "[BillDate] = #" & Me![Combo2] & "#"
If RecordsetClone.NoMatch Then
MsgBox "No Match"
Else
Me.Bookmark = Me.RecordsetClone.Bookmark
End If
Code works fine for dates up to 31/12/00 but produces No Match for
dates > 01/01/01. I'm aware of most of the issues re ambiguous date
formats but can't find anything on the Web for this specific issue.
All help much appreciated.
TIA