Subform within Navigation form won't work

[revolution9540]

I have a database that links people by their username in one table to items that they own in several other tables. I am using a form called SearchForm with a Combo Box to display this information. I want to create a form that can house many forms, including SearchForm. Navigation form is what I want to use to complete this. However, when I drag SearchForm to the [Add New] tab in a blank Navigation form template, I get the following message:



This happens every time I try to open the Navigation form called MainForm. I do not get this message when opening SearchForm by itself. I don't even recall ever setting a parameter of Forms!SearchForm!Combo25 anywhere specifically. Of course, if I enter the person's username in this box THEN the SearchForm works inside of MainForm. But this is not desirable. I've looked through the small amount of VB code in SearchForm and I can't seem to figure out how to get SearchForm to work normally inside MainForm.

Here is the VB code that makes the Combo Box work for SearchForm:

Private Sub Combo25_AfterUpdate()Me.Requery
End Sub

Combo25 operates based on the following query:

SELECT Users.Username, Users.[Last Name], Users.[First Name], Users.DepartmentFROM Users
ORDER BY Users.[Last Name], Users.[First Name], Users.Department, Users.Username;

There is currently no VB code in MainForm. Could anyone help me out here? I've tried various different variations of Me.Requery. I tried code that makes the subform point to the MainForm with no luck.

Any guidance would be appreciated. Thanks!

[John_G]

Are you using SearchForm as a subform on Mainform? If so, then you cannot use the notation Forms!Searchform to refer to it, because subforms are not a part of the Forms! collection.

Instead, use Mainform.subformcontainer.form!Combo25 to refer to the combo box. subformcontainer is the name of the subform control on the main form. Notice that you do not refer to the subform by its name, Searchform.

[June7]

If you are using Navigation form/control, referencing subforms seems to be different than on normal form. Review https://www.accessforums.net/forms/t...orm-32053.html

I don't like and don't use Navigation form.

[revolution9540]

Are you using SearchForm as a subform on Mainform? If so, then you cannot use the notation Forms!Searchform to refer to it, because subforms are not a part of the Forms! collection.

Instead, use Mainform.subformcontainer.form!Combo25 to refer to the combo box. subformcontainer is the name of the subform control on the main form. Notice that you do not refer to the subform by its name, Searchform.

Do you mind me asking where I put Mainform.subformcontainer.form!Combo25? Do I put in in the VB for SearchForm or MainForm? Editing Combo25 in MainForm brings me to edit SearchForm, so there is no separate control for the Combo Box in MainForm.

[revolution9540]

Also, where do I find this so called parameter "Forms!SearchForm!Combo25"? I never actually entered this information. The query for the Combo Box does not have any criteria associated with any of its fields.

[June7]

The parameter pops up because Access can't find the control. Did you review link in post 3? Are you using a Navigation form?

[revolution9540]

The parameter pops up because Access can't find the control. Did you review link in post 3? Are you using a Navigation form?

I did review the link. I am trying to use a Navigation form. So you are certain that there is no way possible for this very simple form with a combo box to work within a Navigation form? Would you suggest different method? I am relatively new to Access, so I am not sure how to make an equivalent navigation-type form from scratch.

[June7]

I am not certain won't work, but all my efforts helping posters with Navigation form have been frustrating. I have never implemented Navigation form. I use form with Tab control.

[revolution9540]

I am not certain won't work, but all my efforts helping posters with Navigation form have been frustrating. I have never implemented Navigation form. I use form with Tab control.

So I tried it with the tabbed form and I am having the same exact problem: I get that same message. This does not appear to be directly related to the Navigation form in that case. I do not understand why such a simple form with one combo box would not work when embedded within another form.

[revolution9540]

This is what the debugger tells me:



I have tried every Google solution for rewriting this line with no luck.

[June7]

You want to requery the subform?

[revolution9540]

You want to requery the subform?

In the original form that actually works, I need that line so when I choose a different selection from the combo box, the form updates accordingly.

[June7]

The combobox is UNBOUND for input of search criteria?

Does this help http://www.allenbrowne.com/ser-62.html

[revolution9540]

The combobox is UNBOUND for input of search criteria?

Does this help http://www.allenbrowne.com/ser-62.html

Yes, the combo box is unbound. And no, that link does not provide any help unfortunately.

[June7]

That tutorial is a well-used example of a search utility.

Exactly how is the combobox used to filter subform records? Dynamic parameterized query (I NEVER use them) or code that applies criteria to form Filter property (you don't show any such code) as in the referenced tutorial?

If you want to provide db for analysis, follow instructions at bottom of my post.