SWilliams answers to your questions: -
The ", " was put into the SQL to cancatenate the companyid with product name.
Ans 1 - Your right tblProducts
Ans 2 - The actual Primary key for the table is ProductID
Ans 3 - ProdName hold the name of the product
By the way I have now had a...
Thanks to SWilliams for the comments. I am trying to replicate the suggested way of doing it am still struggling with the SQL syntax I think. I have run the query in VisData and it worked, any suggestions!!
Below is code I have been using if it helps
sSQL = "SELECT ProductID...
SWilliams asked to see the code, so here it is, probably not very clever as I'm a newbie.
With dbcProductCode ' This is a DBCombo Box
.Rowsource = "datProductTable" ' Data Control Loaded from previous code
.ListField = "Product"
.DataSource =...
I have been trying to drive a DBCombo box in code using a with statement and .Property but the .DataSource property doesn't appear in the list and when I type it in, the debug throuws up an error.
Can Anyone suggest why?
PLEASE CAN SOMEONE HELP ME?
I am trying to design a form with 5 DBCOMBO BOXES on it and know that they have to be attached to Data Controls.
Can I use the same data control and write a short piece of code that will tell the control which table is associated with the control at the Click...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.