MS Access Form message "No current record." box appears?

[ramirezx@ddmfg.com]

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

[Micron]

Always best to avoid errors. In this case it might be by using a more suitable event - not sure which in your case but maybe Current event. If all else fails trap the error and just Resume Next for that error only.