Linking form elements

P

Paul Smith

I would like to design a form that when a user selects one element from a
drop down list the next drop down list will only allow elements that are
allowable for the first choice. I know I will have to create a table
showing the relationship between the choices and choice options.

Can anyone give me any references to show me how to do this.

PWS
 
D

Dirk Goldgar

Paul Smith said:
I would like to design a form that when a user selects one element
from a drop down list the next drop down list will only allow
elements that are allowable for the first choice. I know I will have
to create a table showing the relationship between the choices and
choice options.

Can anyone give me any references to show me how to do this.

PWS
Click to expand...

Here's a good reference. Note that it shows two different methods --
the page itself doesn't make that very clear.

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