requery a combo in subform from main form

[JFo]

I have a main form frmInspections that has a subform frmEquipment



I am trying to requery a combo in subform (cmbEquipDetails) based on a selection in the main forms combo box

I thought this code should work however it is not
in afterupdate of first combo

Forms!frmInspections!frmEquipment.Form![cmbEquipDetails].Requery = True

Any Ideas?

Thanks

[JFo]

Figured it out it is not

'Me.cmbEquipDetails.Requery = True
'Forms!frmInspections!frmEquipment.Form![cmbEquipDetails].Requery = True
[Forms]![frmInspections].[Form]![frmEquipment]![cmbEquipDetails].Requery = True
'Me![frmEquipment].Form![cmbEquipDetails].Requery = True

This one works

[Forms]![frmInspections].[Form]![frmEquipment]![cmbEquipDetails].Requery

Cheers to anyone that had a look

[boblarson]

Figured it out it is not

'Me.cmbEquipDetails.Requery = True
'Forms!frmInspections!frmEquipment.Form![cmbEquipDetails].Requery = True
[Forms]![frmInspections].[Form]![frmEquipment]![cmbEquipDetails].Requery = True
'Me![frmEquipment].Form![cmbEquipDetails].Requery = True

This one works

[Forms]![frmInspections].[Form]![frmEquipment]![cmbEquipDetails].Requery

Cheers to anyone that had a look

Actually, the method you have used is a NON-STANDARD way of doing it and it really should be:
Forms!frmInspections!YourSubformCONTROLNameHere.Fo rm.cmbEquipDetails.Requery

Where YourSubformCONTROLNameHere is the name of the control on the parent form which HOUSES the subform. It is NOT the name of the subform unless the subform control and the subform are named exactly the same.

[JFo]

Thanks for the feedback, yeah I have changed it now and have done many more with the same structure. Here is the link for anyone interested

http://access.mvps.org/access/forms/frm0031.htm

Thanks