I have a table called "Company", in this table is a list box of different dockets. When I click on one of the items in the list box, I get taken to my "JobsList" form and it get filtered by the "DocketNumber" that I picked in the list box. So to flesh that out, I have 15 dockets in my "JobsList" table, but when I click the list box, it filters the JobsList table to one. When I am on the Jobslist form though, I want to take the filter off while staying on the record that I selected from the listbox. Below is the code that I used, and it worked, but now all of a sudden it doesn't work.
Dim ID As Variant
ID = DocketNumber.Value
Forms(Jobslist).FilterOn = False
Forms(Jobslist).Recordset.FindFirst "[DocketNumber]=" & ID
The error I get when I click the "Unfilter" button is
Run-time error '3070':
The Microsoft Access database engine does not recognize [DocketNumber] as a valid field name or expression"
Does anyone know why this might all of a sudden be happening?
Dim ID As Variant
ID = DocketNumber.Value
Forms(Jobslist).FilterOn = False
Forms(Jobslist).Recordset.FindFirst "[DocketNumber]=" & ID
The error I get when I click the "Unfilter" button is
Run-time error '3070':
The Microsoft Access database engine does not recognize [DocketNumber] as a valid field name or expression"
Does anyone know why this might all of a sudden be happening?