Linking two Combo boxes in continuous form

[Guest]

I have a subform (Continuous Form) with two Combo boxes. I want to filter
cbo2 with a selection form cbo1. The subform is based on an editable query
and cbo is bound to one of the fields from that query. cbo1 is used only to
to filter a list for cbo2 and therefore I have cbo1 unbound. I believe this
is why when I select a choice from cbo1 it repeated for all records in the
form. How can I impliment this combo box filter on continuous forms.

Gary

 

[Guest]

Hi Gary,

Try this tip from the folks at FMS:

Data in a combo box control on a continuous form/datasheet disappears
http://www.fmsinc.com/free/tips.html#tip16foraccess

Although you didn't indicate that your data disappears, as the title
indicates, they do offer a sample that you can download. This might be
helpful for you.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a subform (Continuous Form) with two Combo boxes. I want to filter
cbo2 with a selection form cbo1. The subform is based on an editable query
and cbo is bound to one of the fields from that query. cbo1 is used only to
to filter a list for cbo2 and therefore I have cbo1 unbound. I believe this
is why when I select a choice from cbo1 it repeated for all records in the
form. How can I impliment this combo box filter on continuous forms.

Gary