Object doesn't support this property or method

[vanther]

Hi I've been watching this nice forum and really help me a lot.. and now i've got my own problem which i cant resolve this..
I created a next command button but unfortunately when it reached after the last data it says "Object doesn't support this property or method " , before the last messages "You cant go specify records."

code below:

Private Sub cmdForwardLoan_ Click()
On Error GoTo Err_cmdForwardL oan_Click


DoCmd.GoToRecor d , , acNext

Exit_cmdForward Loan_Click:
Exit Sub

Err_cmdForwardL oan_Click:
MsgBox Err.Description
Resume Exit_cmdForward Loan_Click

End Sub

P.s.
please need help thanks

[FishVal]

Hi, vanther.

There is nothing abnormal here. DoCmd.GoToRecor d method raises the error when there is no record to go to. You already have an error handler in your code. It pops msgbox. If you don't want to see this msgbox, then just remove the command popping it up.

Regards,
Fish

[missinglinq]

Look at Mary's (mmcarthy) response to an identical question here, as well as my own, Posts #2 and #3: http://www.thescripts.com/forum/thre...rd+acNext.html

Welcome to TheScripts!

Linq ;0)>