Cascading combo box?

[bfgweb]

Hi, hoping the solution to this question is not so basic to make me appear a fool

This is a question about a 'student records database' providing teachers with their appropriate class lists. I have set up a query with two sets of criteria. Firstly, [Which year do you want eg 7, 8 or 9?] followed by [Which class, eg A1, A2, etc?].

I have a form based on this query which works fine. However what I would like is the user to be able to select a year (7,8 or 9) from a combo box and a second combo box allowing the user to select the class in that year (eg A1, A2, etc) instead of the teacher having to enter the year followed by the class.

Is there an easy solution for an Access novice?

 

[pbaldy]

You have the right name for it. Here's an example:

http://www.baldyweb.com/CascadingCombo.htm

 

[bfgweb]

You have the right name for it. Here's an example:

http://www.baldyweb.com/CascadingCombo.htm

Wow. now that's what I call a support forum - such a prompt reply! Many thanks - will give that a try in the morning.

 

[pbaldy]

No problem; post back if you get stuck.