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 

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

-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"John" <johnlee2509@btopenworld.com> wrote in message 
news:3B407534-4B42-42A8-A119-B7550812B9EB@microsoft.com...
>   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's zip file will probably tell you, but just in case, the concept is
called Cascading Comboboxes.

-- 
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200706/1

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

Regards

John

"John" <johnlee2509@btopenworld.com> wrote in message 
news:3B407534-4B42-42A8-A119-B7550812B9EB@microsoft.com...
>   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