>I have a form that allows the user to enter a date and then press a button to run either a report or process some records. The report is based on a view, and part of the processing for the process records part is also based on a view. I created the views as parameterized views, and the parameter allows the user to select records with a date < the entered date. I can't get this form to work properly. I put a date on the form and did not set a controlsource, as I want any date to be acceptable. In my data enviroment I have set up the view and marked it to not load the data initially. What else am I missing?
In your command button click method, or better yet a separate method on the form, do you have code similar to this:
LOCAL ldDate
ldDate = THISFORM.txtDate.Value
REQUERY( "MyView" )
REPORT FORM MyReport
Chris McCandless
Red Sky Software