passing variables..

[Vincent Jones]

a switchboard that has it's recordsource connected to a stored
procedure. the stored procedure takes two values. a beginning date
and an end date. this then opens the switchboard with the total
hours. i have a text box bounded to the stored procedure with the
total hours displayed. on the switchboard are controls to view
various reports. the reports also take two variables: a beginning
date and an end date. when i click the button to display the report,
the stored procedure prompts me for the two variables again. is there
an easier approach that would allow me to pass those variables the
first time it prompts me.
vj

 

[J. Clay]

I just read this post after replying to your previous post. In this case, I
would probably set default values on the two field of the form and set the
InputParameters values of the form datasource equal to these values. Then
when the button is pressed, you can change the value of the InputParameters
of the form which will automatically trigger a requery.

J. Clay