Update Table on Report Print 1

[JayBall]

I need to update a table when I print a record using a report. I have created a field that prints copy in large letters on my report after the original has been printed but I have no real way of automating the update of the table. I have tried assigning the action to the OnClick event of a button which alson prints the report but it only works for the record which is currently on screen, and my query prompts for the record number, so the system is not fool proof. Any Ideas?

Thanks, Jason.

 

[JoeMiller]

Can your query get the number from the form? If the number is on the form you can replace your [Enter record number] with a reference to the form. Then the query will go to the form to get the value.

[Forms]![MyFormName]![MyRecNbrControlName]

HTH Joe Miller
joe.miller@flotech.net