How can Access auto complete info in a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get a form to auto complete all the (customer information) info
that is already stored in a table....so as not to create several customer
numbers for the same customer....?
 
Hi.
How can I get a form to auto complete all the (customer information) info
that is already stored in a table
Click to expand...

For the steps on how to do this, please see the tutorial on "How to
'auto-complete' a form, with and without code" by using an autolookup query
to automatically fill in information for new records:

http://www.Access.QBuilt.com/html/forms.html#AutoCompleteForm

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
Back
Top