The following line is generating the error: Run time error 3464...Data type mismatch in criteria expression:
Set rst = db.OpenRecordset("SELECT X FROM audit WHERE [X] = '" & Me.x & "';")
"X" is defined as a number in the audit table. Me.X is off a form that is based on the audit table so why am I getting the error?
Set rst = db.OpenRecordset("SELECT X FROM audit WHERE [X] = '" & Me.x & "';")
"X" is defined as a number in the audit table. Me.X is off a form that is based on the audit table so why am I getting the error?
