update date after print

  • Thread starter Thread starter SueR
  • Start date Start date
S

SueR

I have a form that displays all records in a table one row
at a time. I have an option to print any record using a
command button. What I need to do is either change the
current create date (column in table) to todays date when
printed or delete the record after printing. Any guidance
in either of these processes would be appreciated.
 
Sue
Go to the code window and add the following code after the print

Me.CurrentCreateDate=Date 'note that the CurrentCreateDate needs to be changed to the specific name you have for that colum

Vla
 
I have a form that displays all records in a table one row
at a time. I have an option to print any record using a
command button. What I need to do is either change the
current create date (column in table) to todays date when
printed or delete the record after printing. Any guidance
in either of these processes would be appreciated.
Click to expand...

Do it manually.

Just because you hit the print button, until you have it in your hand,
there is no guarantee that the report has actually been successfully
printed. Printers jam, run out of ink or paper, or the guy in the next
office throws it away.

To change the date field to the current date, you can press Ctrl + ;
To delete the entire record, select it, then press 'Delete', or select
it and press the delete tool button.
 
Back
Top