I have an Access 2000 adp front end that uses stored procedures. I need to filter a stored procedure based on what the user selects on another form. The stored procudure runs when a 2nd form is opened, and the diplayed results on the form are based on the filtered stored procedure.



I apologize if I haven't made myself very clear on this.

I quess my question is: is it possible to use information on a form to act as a filter in a stored procedure? I know it can be done with mdb queries.

Thanks