• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Calling all Access Experts!

A

Accipiter22

Banned
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
 
Stick this in the event procedure for the button:

ans = InputBox("what record?")
DoCmd.GoToRecord , , acGoTo, ans
 
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top