Pulling up a record by an index number.

[Briansmi1116]

I have a database, I have been working on, and I would like to be able to search for a record, by typing in the index number to display all of the information. The index number of the table, is the primary key. I would like to either click in the box on the form and enter the number I want to jump to, or double click in the box to open a form to enter the number I want to jump to. Is this possible? Let me know if you need more information, and thanks in advance.

[NeoPa]

Getting a number is easy. Either get the operator to select from a list or allow them to enter it directly.
As far as showing just the matching record is concerned, add a filter to your form (form designed to show all records) which restricts the records to the single matching one selected.