This Code:
Dim db As DAO.Database
Dim rstAttendance As Recordset
Set rstAttendance = CurrentDb.OpenRecordset(Name:="Attendance", Type:=RecordsetTypeEnum.dbOpenDynaset)
With rstAttendance
.FindFirst [Member_ID] = Me.Member_ID
.Edit
![Dues_Paid_Family] = Me.Dues_Family_Years_Paid * Forms!frm_hidden.txt4_Hidden
![Dues_Paid_Single] = Me.Dues_Single_Years_Paid * Forms!frm_hidden.txt5_Hidden
.Update
End With
rstAttendance.Close
Set rstAttendance = Nothing
db.Close
Set db = Nothing
Generates the Error
Run-Time Error 91
Object variable or With Block Variable not set, pointer set on the db.Close statement.
What is up with that????