Use of bookmarks in form recordsetclone

[DevelopV]

I have never used bookmarks!
I want to create a recordset clone on a form, loop though each record and verify data entry.
This is what I have:

Set rstForm = Me.RecordsetClone

With rstForm
    .MoveLast
    .MoveFirst
    
    Do Until .EOF
        If IsNull(Me.cboSalesAreaId) Or Me.cboSalesAreaId = "" Then
            MsgBox "Please enter the ""Sales Area"" for customer """ & rstForm!CustomerName & ".", vbExclamation, "No Sales Area"
            GoTo Exit_cmdClose_Click
        End If
        
        If IsNull(Me.cboDriverId) Or Me.cboDriverId = "" Then
            MsgBox "Please enter the ""Driver"" for customer """ & rstForm!CustomerName & ".", vbExclamation, "No Driver"
            GoTo Exit_cmdClose_Click
        End If
                     
        .MoveNext
    Loop
End With

How do I use bookmarks to ensure that each record is reported? The msgbox should show the name of the customer for the record being checked.

Many thanks in advance

 

[PHV]

As you test Me.XXX don't use RecordsetClone but Recordset ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MajP]

How do I use bookmarks to ensure that each record is reported?

Why do you think you need to use bookmarks, and what do you think they do? I have built thousands of Access database applications and never used a bookmark, and definitely not for verifying data. Cannot see any need here.

 

[missinglinq]

As MajP said, Bookmarks are not used for verifications, but typically to 'mark' a Record, if you will, do something, and then return to that 'marked' Record. Requerying a Form causes Access to move back to the first Record in the RecordSet, which is undesirable, at times, so you'd could do something like

Dim MyBookmark As Variant

MyBookmark = Me.Recordset.Bookmark

Me.Requery

Me.Recordset.Bookmark = MyBookmark

This would note the Current Record, do the Requery, then return to that same Record.

The Missinglinq

Richmond, Virginia

The Devil's in the Details!