How can I update a field in MS Access 2003 via code?
Posted on 2011-03-07
I'm want to keep track of how many times a report is printed. Here is the code that I have thus far to keep track of the print count. When I run this, I get a "Field can not be updated." error box. I'm stumped. Any suggestions?
Private Sub btn_incr_prnt_Click()
On Error GoTo Err_btn_incr_prnt_Click
Dim db As Database
Dim rec As Recordset
Dim N As Long
Set db = CurrentDb()
Set rec = db.OpenRecordset("Certificates")
N = Me.CertID
N = N + 1
Me.CertID = N