Multiple Parameters for Combo Box based on SP

[Databaseguy]

I have Combo Boxes that are based on stored procedures in an Access Data Project.

Currently, I programatically change the next combo down the tier based on the current combos value, and pass the parameter to the next combo.

I.E.
cbo_1 After_Update()
Me!cbo_2.RowSource = "EXEC sp_ColorBox'" & Me!cbo_1 & "'"
Me!cbo_2.Requery
End Sub

How do I pass more than one parameter into the next combo/SP ?

 

[VelNPS]

I am not sure that I have a good idea but..

Could you set the tag property of the first combo box with a value just so you have a place to reference it and then concatenate this into your string with the first parameter to start the next combo box's procedure/record source? It all seems complicated anyway. Are you sure you need a stored procedure or can you just write the record source directly in the after_update event?

Sorry if this was no help.

 

[Databaseguy]

I figured it out

cbo_2.rowsource = "EXEC sp_myStoredProcedure'Param1','param2'"

Thanks though