Hi,
I have VBA code in On Active with the following below. I have this so when the form is active it will re-query and stay on the current record it's on. It works great, but when no records exist I get this error:
Private Sub Form_Activate()
Me.Recordset.Requery
End Sub
Can I add some code that when it finds no records, to just cancel it and just do a Me.Requery instead of Me.Recordset.Requery?
Thanks,
Xavier