By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Pulling up a record by an index number.

P: 76
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
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,186
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.