In the attached the search form works from all textbox's apart from the four date (textbox 3,4,5 and 6).

I suspect it is the format of the date, I think the create record form enters the dates as text, but the search form when looking for >= date is a date so finds nothing or finds the wrong information....

This is one of the biggest code files I have worked on mostly with the help from forums - my skills have been stretched any help would be appreciated.







Data Table - Dummy.xlsm