Printing an uncommitted record

D

Darrell

I have a problem which I repeatedly encounter. I need the user to be
able to print a report which is based on a record just entered, BUT NOT
YET COMMITTED. How do I commit the record when the user clicks "Print"?
It seems like it should be an absurdly simple problem to solve, but I
find myself struggling to do so. Is there no way besides elaborate code
blocks which capture the Bookmark (or a primary key), then requeries,
then returns to the record-of-origin? That seems like a lot of work
merely to commit a record before printing it. Am I missing something?

Thanks in advance for your help.

Darrell
 
P

Pat Hartman\(MVP\)

It is so simple that you'll probably dent your forehead when you go duh!

A single line of code, placed prior to the OpenReport or OpenForm Method is
all it takes.

DoCmd.RunCommand acCmdSaveRecord
 
D

Darrell

Pat said:
It is so simple that you'll probably dent your forehead when you go duh!

A single line of code, placed prior to the OpenReport or OpenForm Method is
all it takes.

DoCmd.RunCommand acCmdSaveRecord
Click to expand...
Thank you, thank you, thank you! I KNEW it couldn't be so complicated! I
didn't know the docmd method existed, and THAT is what I should probably
be denting my forehead for!

Thank you again!

Darrell
 
Top