associate two cmbs without usig parameter query

[Guest]

Hi all,

I am reading another guy ' s form design, there are two comboxes, the change
of one can affect the other, but I can not find the parameter query in the
row source.
How?

Clara

 

[Guest]

Check the After Update event (or any other event) code of the first combo,
mybe there is code that set the row source of the second combo.

Read this link mybe it will give you an example

http://www.databasedev.co.uk/filter_combo_boxes.html

 

[Guest]

Hi Ofer,

Thank you very much for your replay. I have visited your suggested Web site,
it is good. My question is they(the person who wrote these kind of code which
are hard to understand) just assign table's fields to combs to change the
default selection and these table fields have nothing to do with the first
comb selection apperantly. I mean does Access provide such tricks to let a
comb' selection affect a table's field?

Clara

thank you so much for your help