-
No, you can use EOF and BOF in forms- the issue is that you're telling Acces to look for a BOF or EOF, but not telling it what recordset to use- it's undefined.
Try something like:[vba]Dim rs As Recordset
Set rs = Me.Recordset.Clone'<<<make clone of form's recordset
'Check to see if at beginning of recordset
If rs.BOF Then
'Some Action
ElseIf rs.EOF Then
'Some Action
End If[/vba]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules