Send it in using the form's InputParameter property. Set the form's
recordsource to the stored procedure.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz


"Lauren Quantrell" <laurenquantrell@hotmail.com> wrote in message
news:47e5bd72.0310291336.dd6bfe2@posting.google.co m...
> I have a whole bunch of forms that have an unbound StartDate and an
> EndDate field that I have used in MSAccess MDB databases as parameters
> in queries (ie tblEvent.StartDate > Forms!myFormName.StartDate.)
> So, now I'm migrating this beast over to and ADP/SQL Server project
> using Views and Procedures.
> How do I pass the value in Forms!myFormName.StartDate to a Procedure
> and get something that looks like:
> If tblEvent.StartDate > Forms!myFormName.StartDate then ...
> Any help is GREATLY appreciated. This is a major problem before I can
> move ahead with this beast!
> lq
>