G
Guest
How do I limit a dropdown list to a specific set of records in a table based
upon an earlier selection by a user in a form?
upon an earlier selection by a user in a form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Joan Wild
jimbobtnc said:How do I limit a dropdown list to a specific set of records in a
table based upon an earlier selection by a user in a form?
See "Display values in one combo, based on the selection made in another"
http://www.pacificdb.com.au/MVP/Code/ComboRS.htm
G
Guest
I think your are talkiing about cascading combos.
see this site
http://www.rogersaccesslibrary.com/TableOfContents3.asp
it has a downloadable mdb called cascadingcomboboxes.mdb
also see
http://www.mvps.org/access/forms/frm0028.htm
it has sample code.
see this site
http://www.rogersaccesslibrary.com/TableOfContents3.asp
it has a downloadable mdb called cascadingcomboboxes.mdb
also see
http://www.mvps.org/access/forms/frm0028.htm
it has sample code.
G
Guest
How do you get the second list to requery. After a selection is made on the
first drop down the second drop down has the sub list of the first selection
and never changes. Hope that makes sense. Thank you.
first drop down the second drop down has the sub list of the first selection
and never changes. Hope that makes sense. Thank you.
D
Dirk Goldgar
"Edward Jones (Eddie)" <[email protected]>
wrote in message
Requerying the combo box is done by executing a statement like this:
Me!YourComboBoxName.Requery
If you use the technique where the second combo box's RowSource is a
query that refers to the first combo box as a criterion, then you have
to requery it in the AfterUpdate event of the first combo box, and
also -- if these are bound combo boxes -- in the form's Current event.
If you use the alternative technique where you rewrite the combo box's
RowSource SQL statement in the AfterUpdate event of the first combo box,
you don't have to requery it, but -- if the first combo box is bound --
you do have to rewrite the rowsource SQL in the form's Current event as
well.
wrote in message
How do you get the second list to requery. After a selection is made
Requerying the combo box is done by executing a statement like this:
Me!YourComboBoxName.Requery
If you use the technique where the second combo box's RowSource is a
query that refers to the first combo box as a criterion, then you have
to requery it in the AfterUpdate event of the first combo box, and
also -- if these are bound combo boxes -- in the form's Current event.
If you use the alternative technique where you rewrite the combo box's
RowSource SQL statement in the AfterUpdate event of the first combo box,
you don't have to requery it, but -- if the first combo box is bound --
you do have to rewrite the rowsource SQL in the form's Current event as
well.