Report in form Add Mode

  • Thread starter Thread starter Achieva
  • Start date Start date
A

Achieva

I have a form that I am opening in "Add Mode". There is a button on the
form that opens a report, that details all of the records. I would like
that button to only report the transactions from the current "add" session.
If the operator has entered 10 records, the report would only include those
new added records, not all of the records.

How would I limit the report to the current session?
 
Add a boolean field boolPrintIt to the underlying table. The default value
of boolPrintIt is True/Yes. The query for the report must look for
boolPrintIt. The Close event for the report must clear boolPrintIt for the
entire recordset.

In one application of mine PrintIt is an option button on my form. It is
visibly set when the record is created. The Close event of the report asks
permision to reset PrintIt (just in case the print wasn't successful).
Having the button visible on the form allows me to select records to include
in a report.by setting it.

hth
 
Thanks Larry!

one more question ..how do you clear the one field in entire record set of
the yes value?

Ivan
 
You have a good handle on it. For speed comparison you might run an update
query to do the same thing.

hth
 
Back
Top