ms access vba recordsetclone object variable or with block variable not set
Posted on 2013-11-11
I am having trouble with access throwing error no 91: object variable or with block variable not set on my recordsetclone.
In my form I am trying to compare the oldvalue with the newvalue so i can run an audit process if there have been any changes made.
Option Compare Database
Dim rs As Recordset
Private Sub cmdApprove_Click()
If Me.FinalTotalPrem.Value <> rs![FinalTotalPrem] Then
' run audit process
Private Sub Form_Current()
Set rs = Me.RecordsetClone
rs.Bookmark = Me.Bookmark
Can anyone assist as to why am i getting this error?