Open a Form to a Specific Record

[angelinarose via AccessMonster.com]

Hi Gang,
I have a database that has over 25,000 records in it. I have made a form that
users are able to view/modify the data in it. Instead of scrolling through
each record to get to the next record to be reviewed I was wondering if
anyone had a way to open the form to a specific record. I have and EmployeeID
and EmployeeName field. I would like the form to open if one or the other
fields are empty. Is there anyway to accomplish this? I'm lost!

Thanks for the help in advance

 

[Jeff Boyce]

A couple ideas come to mind.

First, if your form is based directly on the table, your form is "loading"
25,000+ rows when it opens. If you'll create a query that limits the number
of records, your form can be based on the query instead.

Also, if you add a combobox in the form's header, you can base that combo
box on a query that returns employees only after 2 (or 3, or 4, or ...)
characters have been entered. This limits how many rows the combobox needs
to load. Then, in the combobox's AfterUpdate event, you can re-query the
form ... which you will have based on a (new) query that uses the combobox's
value as a parameter. The next effect is that the form opens "empty"
(nothing in the combobox, so the form's source query returns no record),
lets you pick an employee (in the combo box), then loads ONLY that
employee's record via the AfterUpdate event.

That should speed performance considerably...

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP