Prevent "Next Record" button from opening new record after displaying last record

[MikeN]

I have an 'edit records' form that opens records associated to a selection made in a previous listbox. I want to put a control button where the user can click to move to the next/previous record but it automatically wants to begin a new blank record once it gets to the end of the available records. How do I stop a 'go to next record button' from opening up a new blank record. I would like for a msgbox to pop up when the user gets to end of the associated records that says something along the lines of "This is the last available record for..."

The 'edit records' form is the same form that the user would use to enter new records...with some different controls (that are normally hidden on the add new record view) and is opened in acFormEdit...so I don't want to change form properties that might influence the 'add new record' form too, if I can prevent it.



Any suggestions?

[ranman256]

set the form property ADD NEW RECORD = false
or
prop: CYCLE RECORDS, set to existing only

[Missinglinq]

Private Sub Go2Next_Click()

  If Me.CurrentRecord = Me.RecordsetClone.RecordCount Then
 
    Msgbox "This is the Last Record Available!"

  Else

    DoCmd.GoToRecord , , acNext

  End If

End Sub

Linq ;0)>

[MikeN]

Thanks Linq! That worked!

[Missinglinq]

Glad we could help!

Linq ;0)>