Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record Count

Status
Not open for further replies.

justlearning2003

Technical User
May 26, 2003
34
CA
Hey,

Do anyone see any problem with this code.

MsgBox "Your record has been sent to the database"

If rstblAllMarkErrorUpdate.RecordCount > 0 Then

On Error GoTo Err_Command26_Click

DoCmd.GoToRecord , , acNext

Err_Command26_Click:

Select Case Err.Number
Case 2105:
MsgBox "There are no more records to view."
DoCmd.Close
DoCmd.OpenForm "Team Leader Agent Feeback"
End Select

End If


Once the code reaches the Msgbox and there are more records to view the code do not go inside the if statement.
Any ideas?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top