Combo and text box

[kevcar40]

Hi
i have a table the fields are
company contact phone num

on a form i have a combo box that selects from the list of companies,
i also have a several text boxes.
is it posible to have the value of the contact and phone_num assigned
to thier own textbox depending on what is selected in the combo

thanks
kevin

[Brian Wilson]

"kevcar40" <ke******@btinternet.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com...

Hi
i have a table the fields are
company contact phone num

on a form i have a combo box that selects from the list of companies,
i also have a several text boxes.
is it posible to have the value of the contact and phone_num assigned
to thier own textbox depending on what is selected in the combo

thanks
kevin

You mean you have multiple contacts per company with each contact having his
own phone number? Normally you would use a subform for this provided your
table structure allows multiple contacts - that is, you would have
tblCompany and tblContact.

[Brian Wilson]

"kevcar40" <ke******@btinternet.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com...

Hi
i have a table the fields are
company contact phone num

on a form i have a combo box that selects from the list of companies,
i also have a several text boxes.
is it posible to have the value of the contact and phone_num assigned
to thier own textbox depending on what is selected in the combo

thanks
kevin

You mean you have multiple contacts per company with each contact having his
own phone number? Normally you would use a subform for this provided your
table structure allows multiple contacts - that is, you would have
tblCompany and tblContact.

[Ken Snell]

See if this article helps:
http://www.mvps.org/access/forms/frm0058.htm

--

Ken Snell
<MS ACCESS MVP>

"kevcar40" <ke******@btinternet.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com...

Hi
i have a table the fields are
company contact phone num

on a form i have a combo box that selects from the list of companies,
i also have a several text boxes.
is it posible to have the value of the contact and phone_num assigned
to thier own textbox depending on what is selected in the combo

thanks
kevin

[Brian Wilson]

"Brian Wilson" <bw*****@ease.co.uk> wrote in message
news:di**********@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...

"kevcar40" <ke******@btinternet.com> wrote in message
news:11********************@z14g2000cwz.googlegrou ps.com...

Hi
i have a table the fields are
company contact phone num

on a form i have a combo box that selects from the list of companies,
i also have a several text boxes.
is it posible to have the value of the contact and phone_num assigned
to thier own textbox depending on what is selected in the combo

thanks
kevin

Just re-read the question - your mention of 'several textboxes' threw me
(don't you mean exactly 2?)
Ken Snell's answer would seem to do the trick.