All, using access 2010; I have a form with a combo box to filter a subform. I had it working fine but someone had access to the database and did something to itL Now the code will not work. I am getting an error: the microsoft access database engine does not recognize as a valid field name or expression.
The master and child links are correct and I have not changed the following code:
Code:
Private Sub cboCustID_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[cust_id] = '" & Me![cboCustID] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
I also tried the following:
Code:
' Find the record that matches the control.
Me.Filter = "[cust_id] = " & Chr(34) & Me.cboCustID & Chr(34)
Me.FilterOn = True
My fault for not backing up but I didn't get too far into this project. Please some one help.