Requery Combo Boxes on a Continuos SubForm



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

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?



Dale Fye

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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question