Best Resolution to Go To Record?

  • Thread starter Thread starter Caittie
  • Start date Start date
C

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
 
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
 
Back
Top