Populate fields in an Access form

[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?

 

[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."

 

[NEC-2008]

What do your tables look like?????

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."