I am working on a form that has a sub form and I'm having trouble getting the sub form to requery when i make a change to a combo box on the main form.
Main Form = Wholesale Orders
Sub Form = Wholesale Orders Subform
When I make a change to the MdlYrID combo box on the main form, I would like the cascaded ModelID Combo box and two other text fields to requery.
Code:
Private Sub cboMdlYr_AfterUpdate()
Me.Dirty = False
End Sub
Private Sub Form_AfterUpdate()
Forms![Wholesale Orders].Form.[Wholesale Orders Subform].Requery
End Sub
The error I keep getting is Run-Time Error 2465
Microsoft Access can't find the field '|1' referred to in your expression.
Not sure what I'm missing. Thanks in advance.