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

FindNext Method

P: 29
How can I attach the findnext method to a spinbutton
so that the control can browse through the values of a
particular field?

Expand|Select|Wrap|Line Numbers
  1. Private Sub SpinButton4_SpinUp()
  2. Dim mjr As Recordset
  3. Set mjr = Me.Major_Link()
  4.  
  5.   DoCmd.FindNext
  6.  
  7. End Sub
Maybe? I don't know.

The field on the form is: Major_Link. This field has a record source linked to
Table![major]![majorlink]

the spinbutton is: spinbutton4

newbie
Jun 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: 29
How can I attach the findnext method to a spinbutton
so that the control can browse through the values of a
particular field?

Private Sub SpinButton4_SpinUp()
Dim mjr As Recordset
Set mjr = Me.Major_Link()

DoCmd.FindNext

End Sub

Maybe? I don't know.

The field on the form is: Major_Link. This field has a record source linked to
Table![major]![majorlink]

the spinbutton is: spinbutton4

newbie
I got it...its all good
Jun 9 '07 #2

Post your reply

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