Fill a ComboBox using SQL statement, and return the primary key of the table
Posted on 2004-08-25
I have a table (tblProducts)
ProductID (int Primary Key)
Now what I want to do is a combo box that will list all the ProductName in the table, but that will return the associated ProductID.
The tricky part: My form has about 30 of these ComboBox, and I dont want to use Datasets, only SQL statements...
Anyone still wants to give it a try ?!