SELECT statement with WHERE clause

[ebo2006]

There are two combo boxes in my form: CORP and CLASS. The WHERE clause of the SELECT statement in the Row Source Property of the CLASS combo box works only every time I start the form. It does not change the list options when I select another ID from CORP combo box. Why is this so?

Here is my select statement

SELECT [tblTYPE].[tech], [tblTYPE].[corp] FROM Courses WHERE [tblTYPE].[corp]=form.ID ORDER BY [tblTYPE].[tech];
 

tblTYPE is the table for CLASS.

Thank you in advance.

[ebo2006]

There are two combo boxes in my form: CORP and CLASS. The WHERE clause of the SELECT statement in the Row Source Property of the CLASS combo box works only every time I start the form. It does not change the list options when I select another ID from CORP combo box. Why is this so?

Here is my select statement

SELECT [tblTYPE].[tech], [tblTYPE].[corp] FROM Courses WHERE [tblTYPE].[corp]=form.ID ORDER BY [tblTYPE].[tech];
 

tblTYPE is the table for CLASS.

Thank you in advance.

Hey guys, you need not reply . I got it. Thanks anyway.