Cascading Combo Boxes and Populating a Form

  • Thread starter Thread starter Marc T
  • Start date Start date
M

Marc T

Hi All,

I've been trying to figure this out all afternoon but have hit a wall, so
thought best to ask the experts!

I have a form that shows information for a particular document (such as
revision, title, various dates). What I want to do is have two combo boxes,
the first for selecting document number, and the second for selecting a
revision within the document number. I'm assuming the first should be an
unbound combo box linked to a query, but how do I feed the second combo box
with the selection from the first, and then pass on information from both to
the form?

Also, as a result of these two selections I am trying to show all the other
info from the record within the form (but show all as blank unless both combo
boxes have a selection).

Any help hugely appreciated.
Marc
 
Hi Gina,

thanks for the tip and link! I think I have it figured out now, just need to
make the form etc a bit easier on the eye now.

Marc
 
Back
Top