Report based on Records in a Form which opens in Edit Mode

  • Thread starter Thread starter Mary McKechnie
  • Start date Start date
M

Mary McKechnie

Hello:

Does anyone know of a way to create a report based on the
records entered into a form which opens in edit mode..a
current subset of records

Purpose...I would like for our data entry person to be
able to get a report to verify entries made during a
session. I know I can go to datasheet view and print from
there..a formatted report would be nicer..Hope that makes
sense, thanks for any ideas

Mary
 
Mary said:
Does anyone know of a way to create a report based on the
records entered into a form which opens in edit mode..a
current subset of records

Purpose...I would like for our data entry person to be
able to get a report to verify entries made during a
session.
Click to expand...

To print a report for a "session". you have to identify the
session that a record was created. This requires a field in
the data table with a session identifier. If you have
multiple data entry people (probably a good assumption), add
another field to the data table for the person's id.

You might be able to use a datetime field for this purpose.
Maybe just use the datetime that the data entry form is
opened using an invisble text box bound to the datetime
field and another text box for the entry persons id? If so,
just use the form's Load event to set the text box's
DefaultValue:

Me.txtSessionID.DefaultValue = Now
Me.txtPersonId.DefaultValue = ???

With that in place, you can print a report filtered to that
session id and person.
 
Back
Top