Hello. Im using Access projects and SQL server, and i was wondering how could i pass the parameters for the stored procedure, which is the rowsource of a report. I dont want access to prompt the user for the parameters if its possible to give them some other way (in VBA).

Cheers,
Tero

you can pass the parameter by first declaring it
Create Procedure pass_parameter
@parameter varchar(20)
AS
SELECT MemberID, ClubName
FROM members
WHERE club_location = @parameter
ORDER BY clubname

Then you will have to create a unbound text column in your access project form and create and event procedure to call your store procedure.