Navigation Form Nightmare

[cdub52]

Hello,



I've tried tons of different VBA to requery a combo box that is in a subform of my main navigation form. I always get a "438" error or Access says that it can't find a field. Some things that I've tried are:

Forms!frmNavigation!frmMain.Form!frmOvertime.Form. txtEmpID.requery, and many other variations.


Help is greatly appreciated!

[hapm]

So what are the exact names for the navigation controls?

[cdub52]

The main form is called Navigation Form
The subform is NavigationSubform
Then the form is FlavorSub

[hapm]

I'm not interessted in the names of the forms, but in the navigation control names on the forms.

[burrina]

Now you say FlavorSub ? Initially you said frmOvertime ??? On what form is txtEmpID on and is it a subform and on what event are you trying to use this code and on what form? One easy way is too create a temporary textbox on the form and use the Expression Builder to refer to the form/control that you need, then use this code to accomplish what you want.

HTH

[cdub52]

I was just using the names.....can you help me with where to find the navigation control names?

[cdub52]

I was just using that string as an example, my form names are different. If I can't figure out this navigation form, then I will have to figure out something else. Thanks.

[hapm]

To find the navigation control names go into your main forms design view, and click only once on the subform control. There should be a border around the complete subform. Then check the properties on the right.

[cdub52]

To find the navigation control names go into your main forms design view, and click only once on the subform control. There should be a border around the complete subform. Then check the properties on the right.

Did that, and it is called NavigationSubform.

[hapm]

Is there another navigation control in you your first subform? If not, you should be able to access the control with Forms![Navigation Form]!NavigationSubForm.Form!txtEmpId if txtEmpId is the name of the control you want to access in your sub form.

[cdub52]

This is the code I'm using now, but it says it can't find the field NavigationSubform....

Me!NavigationSubform.Form!FlavorSub!ProdDescriptio n.Requery

[cdub52]

Is there another navigation control in you your first subform? If not, you should be able to access the control with Forms![Navigation Form]!NavigationSubForm.Form!txtEmpId if txtEmpId is the name of the control you want to access in your sub form.

That should work, right......it doesn't. Lame Access!

[cdub52]

Is there another navigation control in you your first subform? If not, you should be able to access the control with Forms![Navigation Form]!NavigationSubForm.Form!txtEmpId if txtEmpId is the name of the control you want to access in your sub form.

So I tried this, but it gave me the Parameter Box....

Forms![Navigation Form]!NavigationSubform.Form!ProdDescription.Requery

I think it wants another layer for the form in the subform which is called FlavorSub, but when I add that it says that it can't find it.

[hapm]

If the navigation controls name is NavigationSubform then it should work. You don't need the subforms name as it is referenced by the Form property and not by its form name. Use the expression builder to build it up as burina suggested or provide the db with anonymized data as an attachment.

[cdub52]

If the navigation controls name is NavigationSubform then it should work. You don't need the subforms name as it is referenced by the Form property and not by its form name. Use the expression builder to build it up as burina suggested or provide the db with anonymized data as an attachment.

What's the best way to post the attachment?