"go to" text box

[igorin]

Hello,

I have a form where I input and view all the information in my database. The
primary key is a sequence number.

How can I make a "go to" text box so that when I input a sequence number
into it the rest of the fields in the input/view form show the corresponding
values?

Thank you very much in advance.

 

[igorin]

A Combo Box (where you simply select from a drop down list) is not an option
since there are too many records and it would be the same as going forward or
backwards in the form.

Instead I should be able to type in the sequence number I would like to jump
to.

Is it possible? How should it be done?

 

[igorin]

Done! I noticed that you can type into a combo box. Problem solved.

 

[Linq Adams via AccessMonster.com]

FYI, that's called the AutoExpand Property, and is set to Yes by default when
comboboxes are created.