Newb Form/Combobox Expression Question

[Ian]

Hello,

Apologies in advance if this question is simple -- I am fairly
inexperienced with Access, and Googling has yielded little help.

I have a form set up with 3 combo boxes. The first two are lookups
from their own individual queries.
My question is, how to populate the third combo box with the entries
selected in the first two combo boxes?

To illustrate:
Combo Box 1 contains a list of filenames. Combo Box 2 contains a
different list of filenames.
After Combo Box 1 and Combo Box 2 have been filled in, Combo Box 3
should provide a drop-down consisting of the 2 filenames currently
present in Combo Box 1 and Combo Box 2.

Your help is much appreciated.

 

[Arvin Meyer [MVP]]

You should be "drilling down" from the first to the last. I have an example
on one of my MVP websites which drills from 1 list box to a second, then
that one opens the form, to that record. The same methodology applies no
matter how far you drill down:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Gina Whipp]

Ian,

Have a look at this by Arvin Meyer...

http://www.accessmvp.com/Arvin/Combo.zip


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm