Printing a form record prints last printed record from another form.

[gg80]

Usng A2007 and A2003. I have a file with several forms. There are 3 different major forms for each type of device. Each of the three major forms is made up of single forms for a customer and quotation number for that device. The user screen is that same single form for customer and quotation. When the user wants to print the screen, I use code that I found on a website:



Me.NotWantedSubform.visible=False (also allows to avoid landscape format )

Dim PagePrt As Integer
PagePrt = 2 * Form.CurrentRecord - 1 ' Without this, get couple blank pages
DoCmd.RunCommand acCmdSelectRecord
DoCmd.PrintOut acPages, PagePrt, PagePrt


The problem is that when I click to print, it will print the last printed record from one of the other item forms instead of the record on the current form. When I click print a 2nd time, it correctly prints the selected record. I have preceded the code with refresh, requery etc., no effect.

Any help much appreciated-driving me crazy.

[June7]

Save your sanity and build a report to print. I do have a process for printing form but only because it is for archived legacy data and is seldom used, if ever.

You have 3 forms open? Each type of device requires a different form structure?

[gg80]

Problem is that when I try to print a report (different code), get same problem-it tries to re print whatever the last request was. I don't have all 3 forms open at same time. I think that this is a corruption,, I have had some other weird problems. Thanks for reply.,

Save your sanity and build a report to print. I do have a process for printing form but only because it is for archived legacy data and is seldom used, if ever.

You have 3 forms open? Each type of device requires a different form structure?

[June7]

That is weird. Provide the report printing code or the db for analysis if you still need help.

[gg80]

You are right-weird. I pulled out the CD and ran the repair utility and that fixed it. Should have done that before I posted and wasted people's time. This is the 2nd time in past month that I have had to run it (for different reason). Maybe I should remove and re-install? Thanks for pitching in. The expertise available on this site is amazing.

That is weird. Provide the report printing code or the db for analysis if you still need help.