Cannot print from a form

[Ayiramala]

Hello,


I just had a problem with a certain form:
On Form1, I have a check box called SELECT. When I select any one record, the report I get is blank. I need to select one more record to get a print out of the first one. To print any two, I must select those two, plus an additional one. So it is always the number required, plus one. Why is it so? How can I correct this?
Thanks.

[pbaldy]

Where is your code? It sounds like the record hasn't saved, so add code to force it.

If Me.Dirty Then Me.Dirty = False

[Ayiramala]

Where is your code? It sounds like the record hasn't saved, so add code to force it.

If Me.Dirty Then Me.Dirty = False

Thanks for the reply.
I tried it, but unfortunately, it did not solve my problem.

[Ayiramala]

Any other solutions?

[lfpm062010]

pbaldy is correct.

To force a record to be saved before you run your report, you could use:
#1. RunCommand acCmdSaveRecord
#2. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
#3. Me.Refresh
#4. Me.Dirty = False

[Ayiramala]

pbaldy is correct.

To force a record to be saved before you run your report, you could use:
#1. RunCommand acCmdSaveRecord
#2. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
#3. Me.Refresh
#4. Me.Dirty = False

I added Me.Dirty = False to the After Update event of the check box, and it worked! All the time I was trying to use it everywhere, except the check box!

Thanks to everyone for helping.

[cbende2]

Can only the original poster mark threads as solved now?

EDIT: Never-mind, got it.