Best Resolution to Go To Record?

[Caittie]

Currently I'm doing one of those right click on field and filter for options.
It does the job, but a lot of clicking!
I'd like to expedite the process for locating a record.

In my perfect little world, this is what I'd like to see happen on the
subform in question:

This particular form is for data-entry and editing purposes, and contains a
large amount of data.
When a particular record needs to be revised, I'd like to be able to jump
right to the record without eliminating all of the other records around it.

I guess first off.....is this even possible? Or am I only able to basically
requery, eliminating all records outside of defined search criteria?

I've been brainstorming the possibilities for using cascading combo boxes -
since the locating criteria would involve 3 fields:
ie. Field 1 = A Field 2 = S Field 3 = D

I would perfer the user to be able and enter field criteria in any order, and
maybe not even requiring all three field criterias; push a button and the
form is repositioned to the first True record.

Example: If A = 3, B = Null, C = Null the form would reposition to the
first record where Field 1 = 3.
and of the like for any or ALL of the other three fields.

I could go on with more details to my expectancies, however first I believe I
do just need to find out if this "jump" around process is even possible. :c)

Thank you in advance for any suggestions you may have to offer.

Sincerely,

Caittie

 

[Larry Linson]

Yes, what you want to do is possible.

(1) Do you have the cascading Combo Boxes working? If not, take a look at
http://www.mvps.org/access/forms/frm0028.htm or try Googling on the archive
of this newsgroup (or of comp.databases.ms-access) at
http://groups.google.com.

(2) Do you want to have a complete Table or Query available as the
RecordSource of the Form? If so, take a look at
http://www.mvps.org/access/forms/frm0005.htm. If not, then you may need to
use the content of the final cascading Combo Box to construct a Filter for
the Form, or a WHERE clause for the Form's RecordSource.

There are some good suggestions for effective use of newsgroups at
http://www.mvps.org/access/netiquette.htm -- one of which, I am sure, is a
suggestion to search for common solutions at http://www.mvps.org/access.

Larry Linson
Microsoft Access MVP