"go to" text box

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.

--
igor

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?

--
igor


"igorin" wrote:

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.

--
igor

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


"igorin" wrote:

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.

--
igor

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com