getting existing customer data to populate on my form

[Raggy]

I am an getting started with my first form on Access 2010. I very new to using database.


I want to know how I would get existing customer data to populate on my form, say based on a customer’s last name, saving time typing in same customer entries every time.

In other words If I select a last name from a list when adding to my form, I need the first name, phone, and address to automatically fill into the other record entries automatically without having to type them in all the time. Is this possible??

Here is a rough layout of what I mean.

Last Name____First ____Address___ __Phone
Doe _________John ____101 sill lane __658-588-9912
(picked from list) (automatically filled in field based on last name choice)

If I select the last name from a list, can I get first Address and Phone to automatically fill in the fields once I pick the last name.

[justauser]

You will need to link the fields on your form back to the table that you are storing the records. You can do this by setting the form's record source to the table that will keep the records. This is set in the properties table under data. Then you will need to click on each of the fields and set the control source to the fields in your table. This is also done in the same are on the properties table.

[pbaldy]

This type of thing?

BaldyWeb - Autofill

[Raggy]

You will need to link the fields on your form back to the table that you are storing the records. You can do this by setting the form's record source to the table that will keep the records. This is set in the properties table under data. Then you will need to click on each of the fields and set the control source to the fields in your table. This is also done in the same are on the properties table.

I tried this approach. But you still have to select each piece of data from list. I am trying to get each field in record to automatically fill in the box when a last name is selected. Say I put Smith in the first box, then it should know from the table that first name is John and address is say 111 wood st. and automatically put that in the first name field, and address field.

[pbaldy]

Did you see post 3?