Button on a Form to update table

[McFestoe]

I have a button on a form that when pressed prints a report for the customer only, i have been trying to find a way to get the button to update a table that it has been pressed and record some information.

When button pressed it does the following:

Run the report (works)
Update tblhistory
date=()date
Eng= Letter 1
Id = Current Id number of the record shown

Iam asking access for to much, should i be looking at a update query?

Thanks

SOrry if it does not make sense.

 

[Remou]

You need a recordset or an update query, which ever suits best.