Report (form) parameter

[Guest]

I'm using a form to pass a parameter along to a report before opening it.
When I use it successfully, something is causing a "duplicate record" type
error. If I lock the field on my form, and try to open the report, I can't
select anything from that field. But when I close the form a dialog box opens
asking for the parameter which I can type in. This method eliminates the
error.

Any reason you can think of that is causing this duplicate error issue? Or
how I can type this question more clearly?

Thanks!! Neil

 

[Guest]

Neil,

Are you just holding the value (parameter) on the form or are you saving
it to a table?

I have a form that allows the user to enter the start date and end date for
a report. I save the dates to a table just for the query/report to use. The
dates get printed on the report too. when my form opens up it reads the table
to get the dates that are currently stored in the table.

On the form is also a button the user clicks on to run the report if they
are happy with the dates on the form.

I was having problems with the form locking the table and the query/report
not being able to get at the table to see the dates. I had to do some code
that I found in previous discussions to release the table after the form had
done the save to the table.

Am I any where close to what your talking about?
Steve