Navigation / Subform record source and combo boxes

[SalmonDB]

Hi everyone,

I have a form that has a combo box and the record source refers to that combo box. Until I added the form to a navigation form, this was no problem. The form (which is continuous) would just open as if "" (nothing) had been entered in the combo box. The form still opens fine, unless I open it through the navigation form. When I open it through the navigation form, it asks me to enter the parameter from the combo box. I tried changing the record source to reflect the fact that it is now a subform, but this didn't work.

The record source was like this:
Forms![frmMyForm]![cboMyComboBox]

Resulted in: opens fine when opening the form directly, but when using navigation form asks for parameter.

I changed it to this:
Forms![frmNavigationForm]![frmMyForm]![cboMyComboBox]
Resulted in: both MyForm and NavigationForm ask for parameter on open.

Any suggestions? Maybe there's a vba work around to automatically populated the combo box parameter? Or I'm missing something about how to set the record source?

Thanks as always!
Erica