ComboBox Source

[John]

Hi,
Is it possible to have a combobox source set by a selection in another
combobox?

tblSubject has the following fields. Maths, English, Languages etc
tblMaths has the following lessons, Algebra. Trigonometry etc
tblEnglish has the following lessons, Language, Oral, Written etc
and so on.

I would like to be able to select Maths from the first combobox and the
second combobox source be set to the maths table.
Is this possible?

I have done a fair bit of looking around for a solution but cannot find a
specific solution.
I am using access 2007

Reagrds

John

 

[Arvin Meyer [MVP]]

Yes, both combo and list boxes can easily be used this way. Check this demo
for an example of how to do it.:

http://www.accessmvp.com/Arvin/Combo.zip

 

[missinglinq via AccessMonster.com]

Arvin's zip file will probably tell you, but just in case, the concept is
called Cascading Comboboxes.

 

[John]

Many Thanks Guys.
I'll Give it a go!!

Regards

John