Automating Find Record in Form -- Access 2000

[Aloha, Cetaman]

Aloha, I am a newby to this group.
A table and form have been created for an exercise in passenger vehicle
routing. To enter daily passenger count data into the form for each route, I
am now using the "find" option on the menu bar.

How can I make the route field on the form (or a similar box on the form)
change to the correct record (the route number in its field is unique) so the
daily count can be entered in the proper date field for that record without
using the find option on the menu (mentioned earlier)? Is this a VBA or
Macro issue? Mahalo.

 

[John Nurick]

I'm not absolutely certain what you want, but check out the Help topic
"Find a record by selecting a value from a list". Make sure you have an
up-to-date backup of your database before you try it.

 

[Aloha, Cetaman]

Aloha John,

The fifth of six permutations using that option worked. Mahalo! It
even has a next / previous option. Now I must think up something more
difficult. Mahalo again.