Creating an unbound "go to" text box

[StephenB]

I have an issues database that has field "Issue Number" as the primary key and is set to autonumber. I would like to create an unbound text box that when an issue number is entered and you press enter, it takes you to that issue.

This would work similarly to the record number field on the navigation buttons bar.

Essentially, I'm trying to bypass the find button on the toolbar and perform the function on the form.

I appreciate any and all help.
Thanks

 

[ColinEssex]

You could try an InputBox. Check out the access help or do a search here I remember posting the code of how to do this a while ago.

Col

 

[shay]

Try this...


Docmd.GoToRecord acDataForm, YourFormName, acGoTo, Val(YourTextBox)


I'd also suggest using a combo box populated with the available Issue Numbers rather than a text box; that way you won't have to check that a valid Issue Number has been entered.

hth

shay