Restricting one Combo box based on the selection in another field

[Guest]

Hi there,

I am looking to restrict one combo box based on a value selected into a
field from another combo box within access forms.

E.g.
Area on boat: Galley (First field combo box selects Galley)
Items in Area: ??? (Restrict the combo box in this field
based on Galley)

I seem to be able to get it to work for the first selection, but if I change
the Area on boat to another value (e.g. Saloon), the second combo box does
not change to restrict the items in area to be the new values (I.e. saloon
items).

Thanks in advance

 

[Guest]

Hi Doug,

Do you have an AfterUpdate event procedure for the first combo box, which
resets the rowsource for the second combo box?

Forms: Limit content of combo/list boxes
http://www.mvps.org/access/forms/frm0028.htm

How to synchronize two combo boxes on a form
http://support.microsoft.com/kb/289670


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[storrboy]

Hi there,

I am looking to restrict one combo box based on a value selected into a
field from another combo box within access forms.

E.g.
Area on boat: Galley (First field combo box selects Galley)
Items in Area: ??? (Restrict the combo box in this field
based on Galley)

I seem to be able to get it to work for the first selection, but if I change
the Area on boat to another value (e.g. Saloon), the second combo box does
not change to restrict the items in area to be the new values (I.e. saloon
items).

Thanks in advance

You need to tell the combobox to run it's rowsource query again.
In the AfterUpdate event of the first combo, add the following
line.Replace with actual combo names.

Me!ComboBoxName.Requery