Synchronizing Combo Box (brick wall)

[b_best]

I have down loaded and tried many how to's on this. And I keep running into a brick wall.
Attached is a sample file. When a user picked a Audience I need the Sub Audience type to be filter to show only what is needed.



Audience --> Group
Sub Audience --> Sales, Underwriting

Audience --> Marketing
Sub Audience --> Corporate, Finance

Any HELP?

[nick404]

So pick an audience from a combo box and then in a second combo box the corresponding sub audiences filter?
Great tutorial: http://www.datapigtechnologies.com/f...combobox2.html
It should help you solve your problem.

[Missinglinq]

That's about all the help we can give you, without seeing your file! I've downloaded it three times, but in trying to extract it from the ZIP file, it generates an error each time.

Linq ;0)>

[b_best]

Try this new zip file. Had to compress it at a higher level using 7z.

User password is "password"



Tried
tutorial: http://www.datapigtechnologies.com/f...combobox2.html

Still having the same issue. When you click it is asking for the Audience ID #. Not connecting to the # in the sub audience.

[orange]

I recommend you adopt a naming convention that does not allow embedded spaces in field or object names.
And no special characters (#). Use only alpha numerics. This will save you from many syntax issues and frustration.

[nick404]

I am still having problems viewing the attached db, anyone else?

If the link before hasn't solved your issue I would check to ensure that your tables are set up properly so that audience and the sub audience(s) are associated. Could you screenshot your table set up?

[b_best]

Try this link:
http://bbest8.comxa.com/public_html/data/Metrix.zip

[orange]

I opened the database attached in post #4.

[nick404]

Perhaps my work PC is denying me access to these things. I cannot help further as I cannot view db, apologies.

[b_best]

Here is the query code and error message I am getting. (attached)

[b_best]

Ok, I got why the error is happing. Just need some direction as to how to fix it. I have a form with in a form. This is why I am getting the error. When it is on its own I am fine.

(works like this)
Form name is Task_Details2_2 (with the combo boxes) Advisor Combo (main) student_combo (sub box)
code: Forms![Task_Deatails2_2]![Advisor Combo]

This works fine when it is on its own. Once I place this form in another form that is when it looses the connection. How do I do this?

it would be
Contact_Details (main form)
Task_Details2_2 (form with drop downs)

code: Forms![Contact_Details]![Task Details2_2].Form![Advisor_Combo]

This does not work just gives me a blank field so I must be missing somthing?

[nick404]

need . between Form and advisor_combo. You also missed an underscore in task details 2_2.

Forms!Contact_Details![Task_Details2_2].Form.Advisor_Combo

Also just check to make sure you have this behind you sub-combo box and not in another by accident.

[ssanfu]

Form name is Task_Details2_2 (with the combo boxes) Advisor Combo (main) student_combo (sub box)
code: Forms![Task_Deatails2_2]![Advisor Combo]

Somehow the dB must have been changed. I cannot find "Advisor Combo" or "student_combo" anywhere, not even in code.

Would it help if you had a dB with cascading combo boxes to tear apart?

[b_best]

Tried this with such high hopes thank you, But I still get a pop-up box asking for the value. For some reason it is not getting the Audience_ID from the tblAudience-list.

need . between Form and advisor_combo. You also missed an underscore in task details 2_2.

Forms!Contact_Details![Task_Details2_2].Form.Advisor_Combo

Also just check to make sure you have this behind you sub-combo box and not in another by accident.

[b_best]

sorry, Advisor_Combo and Student_Combo are the names of the cmb boxes. they are the Buisness Partners and Sub Partners on the form Task_Details2_2