View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:34 PM
Lauren Quantrell
 
Posts: n/a
Default Passing date fields from form to Access ADP Views

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
Reply With Quote