Auto Complete fields in a form

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

Guest

I am really brain dead this week. I can't remember how to make an Access
form auto fill subsequent fields. For example I choose an employee in a
combobox and his address and company name and phone number automatically fill
in below in the other fields (appropriately named of course). How do I set
that up?
 
Hi.

Or perhaps you're looking for an autolookup query to automatically fill in
the other fields on the form. If so, 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. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Dear bmersereau:

I believe I misinterpreted what you needed... Gunny's suggestion seems more
to the point..

Cheers!
Fred
 
Back
Top