Navigation Form Nightmare

[hapm]

"Go Advanced" an click on "Manage Attachments"

[cdub52]

Here is the zipped folder.....if you can get it to work then you are a genius sir.

[hapm]

How about using Me.ProdDescription.Requery as both controls are on the same form.

[hapm]

And Forms![Navigation Form]!NavigationSubform.Form!ProdDescription.Requery works fine for me.

[cdub52]

How about using Me.ProdDescription.Requery as both controls are on the same form.

The Enter Parameter Value box pops up....no go

[hapm]

So what is the parameter it asks for.

[cdub52]

So what is the parameter it asks for.

Forms!FlavorSub!ProdId

[hapm]

So you use that in the data source of ProdDescription use [ProdId] instead.

[cdub52]

So you use that in the data source of ProdDescription use [ProdId] instead.

Doesn't work....the combo box requery is correct.

[cdub52]

I figured out that the problem is in the combo box that populates based on the previous combo box. It works on the form, but not in the navigation subform.

[cdub52]

I figured it out, thanks. The error was that the combo box query I had. It looked like this for both the combo box query and event VBA code:

[Forms]![Navigation Form]![NavigationSubform]![mycombo1] (for the combo box to refer to another combo box)
[Forms]![Navigation Form]![NavigationSubform]![mycombo2].requery (for the requery)