By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Object doesn't support this property or method

P: 1
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_cmdForwardLoan_Click


DoCmd.GoToRecord , , acNext

Exit_cmdForwardLoan_Click:
Exit Sub

Err_cmdForwardLoan_Click:
MsgBox Err.Description
Resume Exit_cmdForwardLoan_Click

End Sub

P.s.
please need help thanks
Dec 8 '07 #1
Share this Question
Share on Google+
2 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, vanther.

There is nothing abnormal here. DoCmd.GoToRecord 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
Dec 8 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
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)>
Dec 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.