printing problems

[knoppix]

We use access to log in samples in our lab. When the form is filled out we print it since it has all the information on what test need to be done. When we print the page, it actually prints the entry before the one we just entered. The one that was just entered seems to not exist until you close the form and reopen it. This problem did not start until we had a database of 730 samples. We have compress and rebuilt the database but didn't help.

If anyone has any suggestions, it would be great

 

[sfreeman@co.mer]

Probabaly not saved

Are you sure the new record was actually saved before your printed?

 

[WayneRyan]

knoppix,

Put this before you run your report:

DoCmd.RunCommand acCmdSaveRecord

Wayne

 

[knoppix]

DoCmd?

Wayne

Thanks for your suggestion but i'm not sure on where to put the command line.

 

[WayneRyan]

knoppix,

Somewhere on your form, there's a command button for printing the
report. It's a line that looks like:

DoCmd.OpenReport "YourReport", ...

Put the line before that.

Wayne

 

[knoppix]

I have put you suggestion in front of the printout command that my print button uses. Unfortunately it has not solved the problem.

Thanks for the help any ways.

 

[WayneRyan]

knoppix,

Can you post the code for the button? This really shouldn't be that hard.

Wayne

 

[knoppix]

Here is the code for my print button.

DoCmd.RunCommand acCmdSaveRecord

DoCmd.PrintOut acSelection

 

[WayneRyan]

knoppix,

I don't use DoCmd.PrintOut, but the acSelection only prints the selected
part of the current record.

Why not just make a report:

DoCmd.OpenReport "YourNewReport",,,"[RecordKey] = " & Me.RecordKey

That's my only idea at the moment,
Wayne

 

[knoppix]

Wayne,

I am still working on your last suggestion. I can't remember if i mentioned that all of this is being done on a form as pose to a report. Not sure if this is significant or not. Sorry for the over sight on my part.