How can Access auto complete info in a form?

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....?
 
G

Guest

Hi.
How can I get a form to auto complete all the (customer information) info
that is already stored in a table

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top