Calling all Access Experts!

[Accipiter22]

k, so I'm not neffing at work today I"m actually doing work...I think the navigation buttons that Access uses as defaults at the bottom of forms are fugly, so I turned them off and made my own for this form I'm making...I got the goto first, last, and next and previous buttons done...but I can't figure out how to make a field where you punch in the record number you want and it goes to that record...any ideas? Option groups apparently don't work...I tried using a label and a macro using the 'goto' command, but it just goes to the next record for some reason

 

[Wizkid]

Stick this in the event procedure for the button:

ans = InputBox("what record?")
DoCmd.GoToRecord , , acGoTo, ans

 

[Wizkid]

Or create a text box and a button. Call the textbox "RecNum" and then stick this code in the event for the button:

DoCmd.GoToRecord , , acGoTo, RecNum.Value