Automating Find Record in Form

[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.

 

[tina]

in form design view, you can use the Controls Wizard to add a combo box to
"look up" the correct record in the form; once added, you can enter the
route number in the combo box, and move directly to the correct record. just
follow the prompts in the wizard, and post back if you have any problems.

hth

 

[Aloha, Cetaman]

Aloha Tina,

The fifth of six permutations available with the combo box wizard did
the job. Mahalo! It even has a next / previous option once it gets to the
proper route. Mahalo again! Now I have to think up something more difficult.

 

[tina]

Now I have to think up something more difficult.

no, no, not that! <bg, jk>
you're welcome - come on back whenever you need to, we're always here.