Combobox refrence showing up as a Parameter

[littlejib]

I made a form that has a combobox that references the combo box above it, and it all worked fine, then I moved it into a navigation form and it stopped working. This was because the source was still using the static reference of the standalone form, not the subform it is now. So I've changed the row source a number of times, but each time, when run, access fails to find it, instead asking for a parameter to be input. The lines

The Nav form is Navigation_Form, the subform is MCR_Log, the combo box is Affected_Subservices and the referenced combobox is Affected_Services.


The code

 Forms!Navigation_Form!MCR_Log.Form!Affected_Services

or

Me!Affected_Services

does not work, even if I change the bangs and dots around.

I can't attach the file to this forum, so here is a dropbox link to have a play around.

Bonus Question, I want the first combobox to accept multiple arguments, and the second to display all the subservices under each service, would the record source for that look something like

SELECT Subservices.Subservice FROM Subservices WHERE Subservices.Parent = Me!*Affected_Services*;

?

Thanks

[June7]

Review: https://www.accessforums.net/forms/t...orm-32053.html

The Me qualifier works only in VBA, not in Access objects.

AFAIK, a multi-select combobox works only when bound to a multi-value field. A listbox can be multi-select bound or unbound.

No, a WHERE clause cannot just reference multi-select combobox or listbox and capture all the items. Requires code to build a string from items selected in multi-select listbox. Review: http://allenbrowne.com/ser-50.html

If you want cascading comboboxes, review: http://www.datapigtechnologies.com/f...combobox2.html

[littlejib]

Ok, June, the Me qualifier doesn't work in VBA, but I still can't refrence the combobox.

If I use a standalone version of the form, the control

Forms!MCR_Log!Affected_Services

allowes me to do what I want to do. But I can't refrence it when it's a subform in a navigation form. I've tried

Forms!Navigation_Form!MCR_Log.Form.Affected_Services
Forms!Navigation_Form!MCR_Log.Form!Affected_Services

z
Amoung other, be the refrence cannot find the combobox. This is my main problem, the cascading combo boxes work in a standalone form, but not in the navigation form

[June7]

The Me qualifier works ONLY in VBA.

Did the referenced link about Navigation form help?

Is this a web database? I would not use Navigation form unless had to build web database and I have never built a web database.

[littlejib]

It's not a web database, just something I'm developing to help people at work, apart from using a navigation form, is there another way to make multiple forms user friendly.
The refrenced post didn't help his solution was to refrence the box like this

[Forms]![NavigationForm]![NavigationSubform]![FnameTxt]

But that doesn't work, no does adding in .Form behind the subform, or switching the bangs for dots

[June7]

I would use a tab control instead of Navigation control/form.

[John_G]

Hi -

In your expression Forms!Navigation_Form!MCR_Log.Form!Affected_Servic es, what does MCR_Log.Form represent?

If it is the name of the subform, then that is your error - subforms are not a part of the Forms! collection. To refer to a control on a subform you need something like this:

Me!subformcontrolname.form!Affected_Services

where subformcontrolname is the name of the control containing the subform, not the name of the subform itself.

The Me! works fine, as long as it is in the VBA of the main form.

HTH

John