I have a challenge here I was trying to reference a column from unbond combobox it does not work from the query below any idea:
My query looks strange somehow but it works terrific for SQL Server since it only pull one requested record at a time.
Code:
rivate Sub CboQuotation_Click()
Me.txtCboQtyControl = Me.CboQuotation.Column(2)
End Sub
Private Sub Form_Load()
QSQOCCustomerIDLookup.Initialize Me.CustomerID, 3
QSQOCCustomerIDLookup.UnfilteredRowSource = "SELECT CustomerID,Company FROM tblCustomers WHERE Company Like '**'ORDER BY Company;"
QSQOCCustomerIDLookup.IsLazyLoading = True
Me.CustomerID.Requery
AQSQOCCustomerIDLookup.Initialize Me.CboQuotation, 3
AQSQOCCustomerIDLookup.UnfilteredRowSource = "SELECT QryQuotationLookup.Company, QryQuotationLookup.SalesQtyID FROM QryQuotationLookup WHERE Company Like '**'ORDER BY Company;"
AQSQOCCustomerIDLookup.IsLazyLoading = True
Me.CboQuotation.Requery
End Sub
My query looks strange somehow but it works terrific for SQL Server since it only pull one requested record at a time.