subform combo box update, access 03

[tecas]

I have a form with 2 subforms. The main form has a combo box
Department. The subforms contain combo boxes with lists dependant upon
the main form's Department choice. How do I requery the lists of the
subform combo boxes?

Private Sub DepartmentOrValueStream_Change()
Me.cboMachineOrWorkcenter.Requery
Me.frmScrap_Subform.cboscrapchar.Requery
Me.frmScrap_Subform.cboscrapdefect.Requery
Me.frmScrap_Subform.cboscrapcause.Requery
Me.tblDownTime_Subform.cboDTCode.Requery
End Sub

The combobox on the main form updates fine but I receive a compile
error whenever I try to update a combo box in either of the subforms.
Any help would be greatly appreciated.


Thanks,
Ted

 

[Brendan Reynolds]

I have a form with 2 subforms. The main form has a combo box
Department. The subforms contain combo boxes with lists dependant upon
the main form's Department choice. How do I requery the lists of the
subform combo boxes?

Private Sub DepartmentOrValueStream_Change()
Me.cboMachineOrWorkcenter.Requery
Me.frmScrap_Subform.cboscrapchar.Requery
Me.frmScrap_Subform.cboscrapdefect.Requery
Me.frmScrap_Subform.cboscrapcause.Requery
Me.tblDownTime_Subform.cboDTCode.Requery
End Sub

The combobox on the main form updates fine but I receive a compile
error whenever I try to update a combo box in either of the subforms.
Any help would be greatly appreciated.

Try explicitly using the Form property of the subfrom control, for example
....

Me.frmScrap_Subform.Form.cboscrapchar.Requery

 

[tecas]

Try explicitly using the Form property of the subfrom control, for example
...

Me.frmScrap_Subform.Form.cboscrapchar.Requery

Thanks, works like a charm. My second try was
me.form.frmscrap_subform.cboscrapchar.requery. This, of course works
much better.