I have a continuous form that has checkbox of a field that is true/false. The data is based on a joined query, so when the user double clicks on the checkbox, it will change status, then the form is requeried. However, when the form requeried, the record is elsewhere. Can't I use the goto record so that when the form is requeried, the form can go to the record the user was on? Below line doesn't seem to work.
Code:
DoCmd.GoToRecord acDataForm, "frmMyForm", acGoTo, "CustomerID= " & "'" & strCustomerID & "'"
I get the "An expression you entered is the wrong data type for one of the arguments" CustomerID is a string type, so I don't think it's the syntax, but I can be wrong.