CDate not working in the correct format

Hi,

i have a workbook with 3 userforms (to insert data, search data, and add/change data).
Everything is working but i can't resolve a problem regarding the cdata format.

In the frmnewrecord, i have several txtboxes and cboboxes.
The txtbox "End Date" is not supposed to be filled (only after using the add/change data userform). My problem is that if i define the txt box as Cdate, i can't leave it blank. Otherwise the date is inserted in the format "mm-dd-yyy" and not "dd-mm-yyyy" as i need.

I've tryed changing the code in the search data, and add/change data userforms but it just doesn´t work.

Can anyone help me, so i can finalize this workbook?

I send the workbook as attachment

thanks in advance