I have a form that has a main form and then a subform. The subform is linked to a different table than the main form. I am trying to go to the record clicked on the subform. So example
I click an item in the listbox from the subform and the subform goes to that item number. I have tried:
'find the first value that matches
"[item] = " & [frmsubworkorder].[Form]![List4]
'if a matching record was found, then move to it
If Not [frmsubworkorder].[Form].RecordsetClone.NoMatch Then
When I try this I get the following runtime error:
Run-time error '2465':
Microsoft Office Access can't find the fild '|' referred to in you expression.
I have checked and list4 is showing the correct item number.
Any help would be greatly appreciated!! Thanks in advance!