Combo box filter in subform showing blank at form opening

[Gags]

Hello..I have been looking for a solution to this problem for a while but not been successful so far.
Situation is follows:
Am adapting the Northwind DB for my use.
In the Purchase Order details form a Supplier has to be chosen via a combo box. Based on that another combo box in the subform displays products only from this supplier (Products table is linked to supplier table).
I managed to let the subform combo show only relevant products using criteria referring to the main form combo box. Also other product data will show accordingly in text boxes. So far so good. However when I close the form and reopen it the subform combo box is blank, other text boxes still show the right values. If I remove the filter criteria for the subform combo then all fields show all data correctly. (However the combo box is unfiltered again 8-/)
So somehow the 'criteria' prevents the combo to show the value that was previously chosen.



Any idea what I am doing wrong?

Thank u.

[June7]

It is blank because subform loads before main form (I know, weird but that's the way it is) therefore there is nothing for the combobox to reference as parameter. Requery the subform combobox in the main form Current event.

[Gags]

Hi there June.. Thanks a lot..that did the trick! Feel quite stupid now..at the same time smarter ;p