Passing in number to Stored Procedure

[Jusenkyo]

Hello all

I have a stored procedure which requires an input perameter, Contract_No.
I want to run this from VB, and pass in a number from a form.

I know how to do this in a normal access query, but the stored procedures dont seem to allow where clauses to input perameters.

Any ideas?
Cheers
J

 

[M8KWR]

could you post your query (SQL). It should work.

How are you getting the information from the form to to query are you using something like the following

[forms]![FORM_NAME]![FIELD_NAME]

I mostly always use the WHERE clause to query information from a form in a query and have no issues in the past

I hope this helps.