Don't Want to Create New Record When Going Past the Last Record

[kopy]

I've used the Command Button Wizard to create a button that goes to the next record. When I'm at the last record of the recordset, how do I keep it from going to the next record and creating a new record?

Here's my current code.
Thanks, Kopy05
=======================================================
Private Sub Command47_Click()
On Error GoTo Err_Command47_Click


DoCmd.GoToRecord , , acNext

Exit_Command47_Click:
Exit Sub

Err_Command47_Click:
MsgBox Err.Description
Resume Exit_Command47_Click

 

[genomon]

Have a look at the EOF and BOF properties for recordsets in Access help.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."