Question: In SalesLogix I am trying to run a query, and after the query is
executed I would like the results to be displayed in the field
cboProductType. I applied the following code to my form but it's not
Set oCon = Application.GetNewConnection
strSQL = "SELECT DISTINCT(ORDER_FAMILY) FROM BIP_ORDER_HEADERS WHERE ORDER_FAMILY IS NOT NULL"
While Not oRS.EOF
What am I missing?
After you set strSQL you need to populate your result set:
Set oRS = oCon.Execute(strSQL)
When you are finished with
your objects be sure to close and dispose of them. If a sub is
repeatedly called the cbo items append over and over, so consider adding
this as well: cboProductType.Items.Clear