Error

[tmarsh]

I am getting an error on a subform in my main data entry form - run time error 432 - object doesn't support property or method. It occurs when I enter a new record in the main form and attempt to add a course in a combo box in the subform that contains course details.

If I run the debugger I get

Private Sub Form_AfterInsert()
Me![JOB_TITLE].[BASE].DEPT_WARD.Requery
End Sub

flagged and if I select end I can enter data ok.

Where have I gone wrong?

Thanks.

 

[seth_belgium]

DEPT_WARD is the name of the subform? Or is it the name of the combo?

 

[tmarsh]

DEPT_WARD is the name of the subform? Or is it the name of the combo?

Sorry, DEPT_WARD is a field. The error flags whatever field I leave the main form and type in the subform e.g. DEPT_WARD or BASE.