Solved Save date from unbound text box to table

[Gasman]

I have tried your solution and if I select the yesterday date or any other date even present date I get an error.

You have a full stop after the year AND you still do not have the ending #

 

[saledo2000]

i hope this fixed the issue of your Date Regional setting.

I have tried your solution for date format fix and is not working. The first day I took your solution was working perfectly but today does not work. I am access beginner and would need your help. My date format is DDMMYYY. Time zone in Windows settings is UTC + 01:00. I have set date format in cboDate combo box as DD\.MM\.YYYY and I get correct date 01.07.2020., but still get a syntax error

 

[saledo2000]

I've done it. In the code I did not set date format for ThisDate wich is in function set as Date.
strDate = Format(ThisDate, "yyyy\/mm\/dd")

 

[theDBguy]

I've done it. In the code I did not set date format for ThisDate wich is in function set as Date.
strDate = Format(ThisDate, "yyyy\/mm\/dd")

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.