Basing One Combo Box On Another; in a Subform

[Guest]

I found good information on how to filter one Combo Box by selecting a
related column from the same table in a previous Combo Box.

Help was found at:
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx

But I need to be able to use this newly created form as a Sub form. This
way I can relate more that one record from the "Combo Box/s" form to a single
record from a different form/table.

Any Help would be great!

 

[Guest]

Sorry for posting a very simple question.

It seems to make sense to me know thanks to the response to the post "Forms
and Subforms - sharing info between text/combo boxes"

The bit of information I was missing was that the filter I set up for the
second combo box was not referencing the value in the Subform that is on the
main form. It was referencing a value on the form I used to create the
subform.

i.e.
Form with Cascading Combo Box:
[Forms]![Formwithcomboboxvalue]![comboboxvalue]

Subform on main form:
[Forms]![Mainform]![Formwithcomboboxvalue]![comboboxvalue]

I hope this helps somebody who is having the same problem.

 

[Guest]

Sorry for posting a very simple question. It seems to make sense to me know
thanks to the response to the post "Forms and Subforms - sharing info between
text/combo boxes"

The bit of information I was missing was that the filter I set up for the
second combo box was not referencing the value in the Subform that is on the
main form. It was referencing a value on the form I used to create the
subform.

i.e.
Form with Cascading Combo Box:
[Forms]![Formwithcomboboxvalue]![comboboxvalue]

Subform on main form:
[Forms]![Mainform]![Formwithcomboboxvalue]![comboboxvalue]

I hope this helps somebody who is having the same problem.

 

[kristi.waits]

Thanks for the post. This exactly the information I was looking for.
I knew it had to be something very simple, but every search I did on
the subject came back with VBA-related solutions.