Author: hollyquinn | Posted on: 10/20/2008 7:54:36 AM | Views : 275

I am working with a databound drop down list control.  I am trying to recreate a control from an Access 2003 database.  I have the following Access sql statement that is used as the row source.  (I've split it up to make it easier to read)

SELECT DISTINCTROW tblCustomer.CustomerID FROM tblCustomer

WHERE (((tblCustomer.LastName)=forms!frmdatacollection!txtLastName)

And ((tblCustomer.FirstName)>=Forms!frmdatacollection!txtFirstName)

And ((Forms!frmDataCollection!txtGender)<>"F"))

ORDER BY tblCustomer.LastName;

 It's the 3rd line that I'm having problems with.  I'm not sure how to use this when configuring a data source in Visual Studio?  When you click on Where on the configure DataSource screen, you have to select a column.  There is no option to select a control.  When I write this condition into the SQL statement, it provides no results.  Any help on t ...

Go to the complete details ...