Populate fields in an Access form

K

kms

Im working in MS Access 2003 I have 8 fileds customer name, contact name,
street address, city, etc...

I need to have the acct number combo box to populate the form once the
appropiate number is selected. Can anyone help?
 
A

Al Campagna

kms,
When filling in a new order for an existing customer, it's not
necessary to capture the CustName, ContactName, Address, etc...
just display their values.
Since you have captured the AcctNo in your combo, the
other customer info can always be relinked via the AcctNo in any
subsequent form, query or report.

On my website (below) I have a 97 and 2003 sample file entitled
"Combo Populates Multiple Fields." It shows how to set up the combo
so that all the ancillary data "displays" on the form.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
N

NEC-2008

What do your tables look like?????

Al Campagna said:
kms,
When filling in a new order for an existing customer, it's not
necessary to capture the CustName, ContactName, Address, etc...
just display their values.
Since you have captured the AcctNo in your combo, the
other customer info can always be relinked via the AcctNo in any
subsequent form, query or report.

On my website (below) I have a 97 and 2003 sample file entitled
"Combo Populates Multiple Fields." It shows how to set up the combo
so that all the ancillary data "displays" on the form.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
L

Linq Adams via AccessMonster.com

The question here, I think, is exactly what the OP is trying to do. If Al is
correct in his assumption that he's entering in details of an order form and
wants to fill in the customer details, he's correct in saying teh OP
shouldn't do this over and over again, but only draw up these details when
needed, such as when printing an order form out.

If, however, the OP is trying to retrieve an existing record, which could be
true, going by the original post, then Access will do all the grunt work for
him.

Add a combo box to your form.

The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the table or query the form is based on, click on the field you're
searching by (AcctNo in this case) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by,
or you can start to enter the item, and the combobox will "autofill" as you
type. Hit <Enter> and the record will be retrieved.
 

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

Top