Requery through a control within a subform

[Steven811]

Hi

When I select a value within combo box in a subform it then becomes a selection option in another part of the form. I have tried unsuccessfully to set a requery on enter option.

The code I was using was as follows:

An OnClick event

[Forms]![MainForm]![SubForm]![SubForm]![cboBox].Requery

The control is located on the 3rd level of form.

I would also like to retain the record position and not be forced to go to the 1st record.

Any assistance would be great.

Thanks

Steven811

 

[daveUK]

On the After Update event of the 1st combo box try:

Forms!MainForm!SubForm.Form.CboBox.Requery

 

[Steven811]

Looking for a field

Hi Dave

When I run:

Private Sub cboLocation_AfterUpdate()
Form!forCustomerDetails2.Form!ForSiteName.Form!forContactsJobTracking.cboLocation.Requery
End Sub

I get an error message that says that Access can't find the field ForSiteName

When I compile it changes the lower case forSiteName to ForSiteName

Any ideas would be well received.

Thanks

Steven811