Update control from another control

[Guest]

I'm trying to accomplish a task, and I'm not sure how to go about it:

I designed a property management database. I have a table called tblStores
which has all store information (for over 100 stores), including Region,
Regional Director and District Manager (which are all combo boxes).

What I'm trying to do is this: the user will choose the region and the
regional director would show in the next box and the District manager combo
box should show only those DM's in that region (each region has 2).

I hope someone understands my explanation and can provide an answer for me.

Thanks,

Debbie

 

[Guest]

I think you can find your answer in this link on "Limit content of combo/list
boxes"

http://www.mvps.org/access/forms/frm0028.htm

Or, "How can I filter one Microsoft Access combobox based on another
combobox selection" at this link

http://www.databasedev.co.uk/filter_combo_boxes.html

 

[Douglas J Steele]

See whether http://office.microsoft.com/en-us/assistance/HA011730581033.aspx
helps.