Subform query

[Soegstad]

Hi!
I have a subform with a combo box. The combobox has a query with a condition linked to a field in the main form.
What I want is for the combo box in the subforn to show values based on the data in the main form field.

As of now the combobox doen't update itself when I change the value in the field in the main form. It's only updated every time I close down and open the form again.

Thanks.
Mads

 

[Soegstad]

Solved the problem
Just had to put in a requery (Me![frmSub]![ComboBox].Requery) in the main form field.