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 ...