Cascading Combo Boxes and Populating a Form

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

Marc,

Have a look at... http://www.mvps.org/access/forms/frm0028.htm

As for part two, sounds like you will need a form/subform tying the subform
to the combo boxes, hence not showing the results until both are filled in.

--
Gina Whipp

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

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

"Marc T" wrote in message
...
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

"Gina Whipp" wrote:

Marc,

Have a look at... http://www.mvps.org/access/forms/frm0028.htm

As for part two, sounds like you will need a form/subform tying the subform
to the combo boxes, hence not showing the results until both are filled in.

--
Gina Whipp

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

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

"Marc T" wrote in message
...
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


.

Marc,

Glad to help!

--
Gina Whipp

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

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

"Marc T" wrote in message
...
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

"Gina Whipp" wrote:

Marc,

Have a look at... http://www.mvps.org/access/forms/frm0028.htm

As for part two, sounds like you will need a form/subform tying the
subform
to the combo boxes, hence not showing the results until both are filled
in.

--
Gina Whipp

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

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

"Marc T" wrote in message
...
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


.