SQL Server/ MS Access parameter queries

[kena1921]

Hi

I am a fairly experienced MS Access programmer but have less experience of SQL Server. I am building an Access/SQL Server client/server app and I'm looking for some advice on the best ways of dealing with parameter queries.

For example I have a form in Access with a dropdown. I need to take the dropdown value, use it as criteria in a query, send this to the SQL data and display the returned results on the form etc. I have been trying to achieve this using a pass thru query - I'm ok with getting a non paramter pass thru to work but what I'm unsure of is getting it to work whilst passing the paramter. I suspect I need to use a query def but I'm unsure how.

All advice gratefully received, this is fairly urgent - some simple examples would be of great use.

Many thanks

Ken

 

[bborissov]

I think that question you should ask in Access forum here.
It is more related to Access than to SQL Server.
BTW check this:

http://bytes.com/forum/post791563-4.html

Not sure if this will work for you

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.