J
Jayyde
Can someone please tell me what I'm doing wrong this time =\. This code is
causing the form to pop up input boxes asking me to enter parameters that
are already in it's strSQL that's getting passed or one of the variables
coming back from it's strSQL. It's asking for input for sDisplayName and
iProductTypeId...
CODE:
intTypeID = cboType.Column(0)
strSQL = "SELECT dbo_tblProductCategoryTree.iProductCategoryTreeId, " _
& "dbo_tblProductCategoryTreeId.sDisplayName " _
& "FROM dbo_tblProductCategoryTree " _
& "WHERE dbo_tblProductTypeId=" _
& intTypeID _
& " ORDER BY dbo_tblProductCategoryTree.sDisplayName"
cboTree.RowSource = strSQL
I'm guessing it's asking for the sDisplayName because of the order by thing,
but still, it should all be coming back fine. The only thing this rowsource
changes from the original is the WHERE clause.
causing the form to pop up input boxes asking me to enter parameters that
are already in it's strSQL that's getting passed or one of the variables
coming back from it's strSQL. It's asking for input for sDisplayName and
iProductTypeId...
CODE:
intTypeID = cboType.Column(0)
strSQL = "SELECT dbo_tblProductCategoryTree.iProductCategoryTreeId, " _
& "dbo_tblProductCategoryTreeId.sDisplayName " _
& "FROM dbo_tblProductCategoryTree " _
& "WHERE dbo_tblProductTypeId=" _
& intTypeID _
& " ORDER BY dbo_tblProductCategoryTree.sDisplayName"
cboTree.RowSource = strSQL
I'm guessing it's asking for the sDisplayName because of the order by thing,
but still, it should all be coming back fine. The only thing this rowsource
changes from the original is the WHERE clause.