I have a process where I extract a number into a variable and I need to filter a recordset by that number. I cant seem to find a method to make this work, the recordset is a linked table.
'Set rst2 = CurrentDb.OpenRecordset("dbo_Proposal", dbOpenForwardOnly)
Set rst2 = CurrentDb.OpenRecordset("select * from JobTest WHERE [Proposal Number] = '[txtJob]';")
If rst2![Proposal Number] = null Then