Hi All!
I have an append query to which I'd like to pass as parameter the value of a combobox from a form.
So in the query definition grid I put [strParam] for the ITEM field which I want to pass, in Query->Parameters I defined [strParam] as text. In the form I'm doing the following but it doesn't work... I get the error "too few parameters":
Dim strPARAM As Parameter
Set qdf = dbf.QueryDefs("QueryS4"
qdf.Parameters!strPARAM = Me.ComboItem.[Column](0)
qdf.Execute
Could you please help me pass the combobox value to my query?
Thank you, Gabriela.
I have an append query to which I'd like to pass as parameter the value of a combobox from a form.
So in the query definition grid I put [strParam] for the ITEM field which I want to pass, in Query->Parameters I defined [strParam] as text. In the form I'm doing the following but it doesn't work... I get the error "too few parameters":
Dim strPARAM As Parameter
Set qdf = dbf.QueryDefs("QueryS4"
qdf.Parameters!strPARAM = Me.ComboItem.[Column](0)
qdf.Execute
Could you please help me pass the combobox value to my query?
Thank you, Gabriela.