I'm attempting to run an update on a table, and to do so I need to grab a date from my form control (AdmitDate - formatted as short date) and compare it to an existing AdmitDate in my access database (also set to "Short Date")
So Where clause looks like:
"Where AdmitDate =" & Me.AdmitDate & "" which generates the SQL just fine as Where AdmitDate = 4/5/2010
However, I am updating 0 rows no matter what. I can't figure out for the life of me what is going wrong here. Both the text control is shortdate format and the database field is shortdate format. In fact, the AdmitDate text control is what is entered into the database upon record insertion. So the damn date exists and I can see it plain as day in the raw table data. My query just won't pick it up??