This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From29/07/1997 15:06:52
Michel Martel #010943
Analystik Inc.
Montréal, Quebec, Canada
To  
All


We want to write a SQL statement in a ComboBox RowSource with a Where clause depending of an Entry Field of the same Form.

The only way we have found is to put the EntryField.value in a Public Variable and do :
Select field1 from Table1 Where Table1.Field2 = PublicVariable

It does not work when we want to do :
Select field1 from Table1 Where Table1.Field2 = ThisForm.EntryField1.Value

If someone have an idea about the right syntax !!!

Analystik team.
Analystik Team
1430 Belanger
Montreal (Quebec)
Canada
(514) 278-2727
analyste@analystik.ca