I have a form with textboxes displaying dates from a monthcontol. My access table has those coorisponding dates as Date/Time fields.
The update query has a nested IF that needs to identify if the form textbox has a value, if not it needs to insert Null into database, else input the value from the form textbox.
See query below
I keep getting a Data mismatch error and cannot figure it out. I have tried various iterations of code to fix. Above is only an example of several failed attempts.
Thanks for any help
Bookmarks