Requery on SubForm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Form and a Subform.
They are linked throught a field. So far so good, it works.

In a SubForm I have a Combobox with a query as a RecordSource based in a
value from the Main Form. This combo displays (should) a value list, but this
depends on a value that is in the main form, and it doesn't work.
There is no errors. Simply doens't work. The combo always displays the same
data.

What should I do? Any sugestions?

Thank you.
 
On the after update event of the field in the main form you need to refresh
the records displayed in the Combo in the SubForm

Me.[SubFormControlName].Form.[ComboName].Requery
 
Back
Top