filter or "jump to" feature

[blee via AccessMonster.com]

Hello and thanks for previous help. Still pretty new to this (KISS), but
learning...

I have a table with a list of athletes, an autoID unique #, parents, address,
phone #'s. I have a second table which holds information about injuries which
occur in the season, which has athleteID (from previous table), location of
injury, etc; this data is entered via a form.

The problem is now that my list of athletes is growing (will be 600 or so),
it is too cumbersome to look through that whole list (via lookup box) to find
the particular athlete I want when entering the injury data. So, is there a
way to begin typing in the athlete ID box on the injury form, and have it
jump to the place in the list which correlates? (like entering your state on
a web form-->typing in "N" pulls up NC, etc)? Or perhaps there is a better
way altogether??

THANKS FOR YOUR HELP!!!!!!

Brian

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200609/1

[Rick Brandt]

blee via AccessMonster.c om wrote:

Hello and thanks for previous help. Still pretty new to this (KISS),
but learning...

I have a table with a list of athletes, an autoID unique #, parents,
address, phone #'s. I have a second table which holds information
about injuries which occur in the season, which has athleteID (from
previous table), location of injury, etc; this data is entered via a
form.

The problem is now that my list of athletes is growing (will be 600
or so), it is too cumbersome to look through that whole list (via
lookup box) to find the particular athlete I want when entering the
injury data. So, is there a way to begin typing in the athlete ID box
on the injury form, and have it jump to the place in the list which
correlates? (like entering your state on a web form-->typing in "N"
pulls up NC, etc)? Or perhaps there is a better way altogether??

THANKS FOR YOUR HELP!!!!!!

Brian

The current athlete ID box you have is bound to that field in the table so
if you start typing in it you are CHANGING whatever record you are
positioned at (not what you want).

A second unbound ComboBox for navigatiing is what you want and the ComboBox
wizard will build this exact thing for you. Just drop a new ComboBox onto
your form making sure the Toolbox wizard is turned on and take the third
option in the wizard. It will be labelled "Find a record on my form based
on the value I selected in my combo box".

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com