submenus

[Jeff]

Hi there.
I'm using AccessXP

I have a form containing information on teachers. One of the fields contains
the language that that teacher teaches, English or Spanish.

There are two submenus with the list of classes that that teacher teaches.
One of the submenus will be blank as no teacher teaches the two languages.

I want to eliminate one of the submenus from the form and have one submenu
alter to show the English or Spanish classes, depending on the language that
is in the language field.

Any help would be greatly appreciated.

Thanks, Jeff

 

[CJ]

A couple of questions, I'm a little confused but i'll try to help ya..

1) What is the field type of the field that contains the language the teacher speaks

2) Is there any information pre-set into the submenus based on language

 

[Gary Miller]

Jeff,

If you put all of the classes into one table and have/add a
field for the Language the class is taught in you should be
able to something similar to the following after you adjust
the field/table names to match yours...

Your combobox Rowsource:

SELECT Class FROM tblClasses WHERE Language = '" &
Me!Language & "'"

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________