How do I pass a Form value to a VW, SP or FN in SQL Backend?

[Ice Rhino]

Not sure whether this question should be in Sql or here but seen as it is sort of query related I will post here.

I have an ADP application that contains a form. On this form is a number of combo boxes. I wish to pass the value of one of these boxes into a vw, sp or fn (pref vw) so that a simple query that populates another combo box with a filtered result based on the selected criteria in another cbx.

In Access applications I would normally just use something similar to

Like "*" & [Forms]![frmDashBoard]![txtinvpor].[Value]

However if I try any variant of this in the query under criteria now that I am running an adp application, it errors everytime saying 'Data Type error in expression'

Anybody help he out with this please?

 

[Ice Rhino]

Is it something to do with the default value of the box being an * and then gets changed to a number field?

The only reason I ask is because if I place * in the criteria section manually I get an error similar, but if I put a number in the criteria it chnages it to = 1

Just thinking aloud