Combo selection populating second combo

[Kerri Storr]

Hi,

I'm sure I've done this before but I can't remember how:

I have 2 combo boxes, both on the same form.

- The first lists releases (lookup on tbl_releases)
- The second one lists change requests (lookup on tbl_chg_req)
Both tables have "release" as part of the key i.e. there are many change requests to one release

I would like the second combo box (change requests) to be populated only with the data relating to the release selected in the first combo box. And change each time a new release is selected. Hope that makes sense!

Is there some sort of push / pull functionality for combo boxes?

I don't want to refresh the whole form as it will cause problems elsewhere.

 

[Hayley Baxter]

Have a look at this post there are two examples of cascading combo boxes attached here.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34135

Hay

 

[Fizzio]

Have the criteria for the field you want to filter on in the query for combo2

eg =Forms!NameofForm!Combo1

Then on the afterupdate of combo1

me.combo2.requery

 

[Kerri Storr]

hmmm

Thanks Fizzio. I've tried it but is still doesn't work.

Hayley, I can't find the samples you mentioned