469,317 Members | 1,963 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Pulling up a record by an index number.

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.
Mar 4 '08 #1
1 1620
NeoPa
32,173 Expert Mod 16PB
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.
Mar 6 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Skully Matjas | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.