I am getting run time error 7951 "You entered an expression that has an invalid reference to the recordset clone property., on this statement
gBogusLong1 = Me.RecordsetClone.RecordCo
unt whic is part of this code block
Private Sub Form_Current()
If Me.NewRecord Then 'should never be a new record on this form
gBogusLong1 = Me.RecordsetClone.RecordCount
If Me.RecordsetClone.RecordCount > 0 Then 'only do this if records exists.
' Set up globals for the current tax record, different id's are on it.
gCurrGRBID = Nz(Me.GRBID, 0)
I copied this code block from another Access 2013 application, where it works with no issues. .
The purpose of the code is to save off the ID of the first record on the continuous screen after a requery but only if there is a record. If the returned recordset has no records I want to bypass the setting of the ID.
Any ides why I am getting this error in this application but not the other. Or, Is there a better way to accomplish what I am trying to do?
If I try to type the command in using the intellisense there definitely in no 'Recordcount' option available.