By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

SELECT statement with WHERE clause

P: 30
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

Expand|Select|Wrap|Line Numbers
  1. SELECT [tblTYPE].[tech], [tblTYPE].[corp] FROM Courses WHERE [tblTYPE].[corp]=form.ID ORDER BY [tblTYPE].[tech];
  2.  
tblTYPE is the table for CLASS.

Thank you in advance.
Dec 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: 30
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

Expand|Select|Wrap|Line Numbers
  1. SELECT [tblTYPE].[tech], [tblTYPE].[corp] FROM Courses WHERE [tblTYPE].[corp]=form.ID ORDER BY [tblTYPE].[tech];
  2.  
tblTYPE is the table for CLASS.

Thank you in advance.
Hey guys, you need not reply . I got it. Thanks anyway.
Dec 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.