I want to open a recordset (rst1) based on a numeric value (called "ControlNumber"). The value of the ControlNumber is obtained from an input box. The ControlNumber is an integer value.
Here is the line of code that doesn't work:
rst1.Open "Select * From qry_Myquery Where ControlNumber = """ & varControlNumber & """"
I can't figure out where the tick marks go. Thanks in advance.