Page numbers not synching up with Record numbers when printing

[SilverFox]

I have created a form titled WORK ORDERS and this uses a Job No set as an autonumber and is the primary key. I have created a report to print records form the form so that they can be handed to employees to do the required task.



The problem I have is when adding new forms and going to print them in the report. I have created a print report button that takes me straight to the report and its set to open in print preview to make it easier for the user. When they select the page number they want to print it ends up printing a completely different record from the Work Orders. Every time I have deleted the record and redone the autonumber it still jumps out of synch with the page number on the report and its frustrating the hell out me!

Why is this doing this and how do I rectify it and to ensure it doesn't do it again? I have no experience with VBA at all as that stuff confuses the hell out of me!

Any help would be greatly appreciated.

Thanks

[Bob Fitz]

Can you post a copy of the db

[SilverFox]

Can you post a copy of the db

Are the images satisfactory? This is the issue I am faced with

[CJ_London]

Don't think that is what Bob meant by a 'copy of the db'. But I can say that you should not rely on autonumbers to mean anything other than a unique identifier to a record. Certainly you cannot link an autonumber and a page number

[Bob Fitz]

Ajax is quite right. When I said a copy of the db, I meant exactly what I said. "A copy of the DB". At least the pictures help a little in understanding your problem.
You could restrict the output of data to the report, so that only the required record is in the report. Then the user need not worry about what page to print.
That what I would do.

[Gicu]

As others suggested use the Where clause of the Docmd.OpenReport method to specify the current JobNo loaded in the form (the one you want to print):
https://docs.microsoft.com/en-us/off...cmd.openreport
Post back your code (enclosed in the # code tags) if you get stuck.
Cheers,

[SilverFox]

I have tried attaching the database but it will not upload which is frustrating

[Gicu]

You need to run a compact and repair to shrink its size than zip it.

[Bob Fitz]

I have tried attaching the database but it will not upload which is frustrating

There is a button you can press at the very top of each thread with the words "How to Attach Files" which will give you detailed instructions.

[SilverFox]

Thank you all for your help I have stumbled onto another method of printing each form by creating a button on the form and selecting preview report. I can now open a report just for that record and print if off This does away with the reports all being opened at once and trying to link autonumber to page number.

[Bob Fitz]

That sounds like an excellent solution. Glad we were able to help you.