Searching for dates, only works for July!!

[chrisbrooke]

I know this sounds like an easy one, and it should be. Im using the wizard to link to a text box in a form to a date field in a table (both configured with a short date input mask). Right, try an explain this...it works fine for dates in July, i.e it brings up the relevant record, but when I type in a date of august or september it dosent work!!!! It just wont find the record, even though its the same configuration as the dates that do work. Im baffled!!! Help.

 

[namliam]

See http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=213077#post213077