autopopulating a field

[Guest]

I have a table with jobs we are currently working on, and they each have a
work order number. However most people don't go around memorizing the work
order numbers. How can I make the work order field autopopulate with the
correct work order # when I enter the job name in other forms?

 

['69 Camaro]

Hi, Denise.

How can I make the work order field autopopulate with the
correct work order # when I enter the job name in other forms?

Please see the article, "'Auto-complete' A Form, With or Without Code," on
the following Web page for an example of one way to do this:

http://www.Access.QBuilt.com/html/auto-complete_form.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.