Date format from textbox to filter - text to date formate issues

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

I have added this into my file.... thanks AlphaFrog for that.

If I use the new record form to add new record it adds the dates into the columns with general format (not a date format).

The search form is finding the new record but not as a date (I think its text/date problem), looking into this further if i use the filter option on the worksheet it sees the original dates as dates and the new dates as text.

I need the search function on the date cells to look for greater than or equal to, all the others a exact match.

I think I have created this problem with the way the whole file has evolved with snippets learned from searching rather than knowing what I am doing.

I can add the amended file if needed, but it will have to be after work.

AlphaFrog thank you for you continued help.

The add form I changed the line to:-

Please Login or Register  to view this content.

The view forms Amend and Duplicate line I changed the line to :-

Please Login or Register  to view this content.

But the search form I changed to

Please Login or Register  to view this content.

but then in the search clear code I added:-

Please Login or Register  to view this content.

Thank you again, could see the error but had no idea how to fix.