Access Drop Down List on Forms

A

AmytDev

Can anyone tell me how I could control the options of one drop down list by
the results of another drop down list on an Access Form?

I have one location table that populates the drop down list options and
whatever the user selects as the location, they will only see the options
that apply to that specific location in the second drop down list.

Please help.
Amytdev
 
A

AmytDev

Thank you so much! That was exactly what I needed.

Ofer said:
You can have a look at this link, it will give you one option.

http://www.microsoft-accesssolutions.co.uk/filter_combo_boxes.htm
===============================================
The other option will be, to link the rowsource property of the second combo
to the field that link the two combo's in the first combo

Select FieldName From TableName Where FieldName =
Forms![FormName]![Combo1Name]

Can anyone tell me how I could control the options of one drop down list by
the results of another drop down list on an Access Form?

I have one location table that populates the drop down list options and
whatever the user selects as the location, they will only see the options
that apply to that specific location in the second drop down list.

Please help.
Amytdev
Click to expand...
Click to expand...
 
Top