Need help with Autonumber

[davin2929]

I have a data entry form that updates a master table. Each record has an index number (autonumber). I would like to have a "next" and "previous" button so I can cycle through the table and pull the information to the form.
I've gotten as far as creating the two buttons but have no idea how to code them. if someone has any help out there it would be greatly appreciated. thanks!

 

[Norie]

Can't you just use the built in navigation buttons?

 

[davin2929]

I got it thanks!

 

[Bubbis Thedog]

I'd like to add to this...

I added code to one of my buttons on a form, but when I tried to add code to a second one on the same form, it wouldn't recognize the target text object's control source?

I noticed that the second buttons Sub was in the same procedure as the first button. Is this what's causing the problem? That is, do I need to enter the second button's code somewhere else?

 

[Norie]

What do you mean it was in the same procedure?

Can you post the actual code?

 

[Bubbis Thedog]

Hi, norie. I really appreciate you helping me out today!

I right-click Button 1, and use the builder in the On Click event property field to take me to the VBE. I enter this stupidly simple code that enables the EXT_ID and EXT text fields when Button1 is clicked:

Private Sub Button1_Click()

   [EXT_ID].Enabled = True
   [EXT].Enabled = True

End Sub

Now, when I right-click Button2 and click the builder elipses in the On Click event property field, the VBE opens again, and has put

Private Sub Button2_Click()
End Sub

in there for me, below the Button1 code as stated above.

So, I enter between this code

[HG_ID].Enabled = True
[HG].Enabled = True

...and I get an error!

Now, HG_ID is for certain in one of my target fields, as well as HG in another, because when I exit design mode, the numbers are in there. What's going on, you think?