I have a stored procedure in Access as:<BR><BR>SELECT *<BR>FROM newproducts<BR>WHERE [P_Manufacturer]=[@manufacturer] And [P_Category]=[@category]<BR>ORDER BY [P_ID];<BR><BR>I want to pass the variables in like this:<BR><BR>strSQL = "ViewProducts &#039;" & manufacturer & "&#039;, &#039;" & category & "&#039;"<BR><BR>I can get the Stored Procedure to work no problems in access when inputting values, however I want the default to list all products but * doesn&#039;t seem to be working as it would if I had written:<BR><BR>SELECT *<BR>FROM newproducts<BR>WHERE [P_Manufacturer]=* And [P_Category]= *<BR>ORDER BY [P_ID];<BR><BR>I know normally I should just write SELECT * FROM newproducts, but I want to simplify the coding by using a stored procedure for everything I need in this particular page. How do I do it?<BR><BR>Lloyd