Newb Form/Combobox Expression Question

  • Thread starter Thread starter Ian
  • Start date Start date
I

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. :)
 
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
 
Back
Top