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