Can someone help please?
I have a userform for updating my table with various date fields in textboxes, when the data is transferred to the table i am using CDate to ensure the correct format "dd/mm/yyyy" is transferred, which is all working fine, however, my problem is i have a command button to search the table and return a record from the table back to the userform, this is where the incorrect date is coming back as "m/d/yyyy" this is my search code below, can someone suggest an edit so I can return the correct date format back to the userform. Ive underlined the date fields.
Bookmarks