Requery Combo Boxes on a Continuos SubForm

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

I have a continuos SubForm that contains dependent combo boxes on each row.
For some reason, the combo boxes show blank values when records are changed,
mainly after a "NotInList" event successfully finishes on any of the combo
controls.

The below code show work fine if my SubForm contained only one combo box
control, but how can I refresh all combo controls on a continuos subform?

Is there a way to use some type of "For Each Control ..." loop to iterate
through each combo on each row of the continuos SubForm?

CODE:

Forms!frmMainForm!frmSubForm.Form.cboBox.Requery
 
Have you tried just requerying the entire subform?

If you are concerned about moving off the current record in the subform, you
could store that records PK value, requery the form, then do a findFirst to
move back to the correct record.

Dale
 
Back
Top