Limit entries in dropdown list based upon earlier selection in th.

[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?

 

[Joan Wild]

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

 

[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.

 

[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.

 

[Dirk Goldgar]

"Edward Jones (Eddie)" <[email protected]>
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.