RE: Filter data in a query using a control as parameter
paolob
- create a form with "record origin" set to QInfoFornitori
- set "record origin qualifyer" to dbo
- set "Input parameters" to @Forms___Qhomepage___Ragione_so1 =
[Forms]![Qhomepage]![Ragione_sociale1]
This solution works for me. Hope this can help.
Paolo
"paolob" wrote:
> I upsized data from Access 2007 to sql Server 2005 and I created a
> client/server application. I'm not able to restore some functionalities I
> used in the Access interface before the upsizing porocedure.
> I need to filter some tables according to a value set on the form. In Access
> the query looks like this:
>
> SELECT ClienteFornitore.Cliente
> FROM ClienteFornitore
> WHERE (((ClienteFornitore.Fornitore)=[Forms]![Qhomepage]![Ragione_sociale1]));
>
> Once the I upsized the database the following code, that refers to a contron
> on a form, is not recognized: [Forms]![Qhomepage]![Ragione_sociale1].
> The upsize procedure traduced automatically the query in a view in this way:
>
> ALTER FUNCTION QInfoFornitori (@Forms___Qhomepage___Ragione_so1 varchar
> (255))
> RETURNS TABLE
> AS RETURN (SELECT ClienteFornitore.Cliente
> FROM ClienteFornitore
> WHERE (((ClienteFornitore.Fornitore)=@Forms___Qhomepage___Ragione_so1)))
>
> I can't understand how to connect the variable
> @Forms___Qhomepage___Ragione_so1 to a control on a Access form.
> Can someone help on this?
> Thanks
>
> Paolo