RowSource Problem

[georgp]

Hi,

I have a combobox with the following - working - VBA code, which restricts the dropbox selection to the items related to combobox cbo_Fld0:

cbo_Lot0.RowSource = "SELECT Distinct LotName from tbl_ProdLot Where [ProdNo] = " & cbo_Fld0.Column(2)

However, if I try to put the code into the property window of the control, the 'cbo_Fld0.Column(2)' expression is not accepted.
What is the correct syntax?

Thanks, georgp

 

[Steve101]

Try putting your code in the AfterUpdate event of the combo box. If you need further direction, post back.


Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[Steve101]

Sorry, further clarification; put the code in the afterupdate event of the cbo_Fld0 field.

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)