Auto filled in values from another form after choosing value from list box.

[AA Arens]

Hello,

Clients database.
I do have two forms accessible from the Switchboard.
The first is to fill in company info.
The second to fill in contact person and the company he works for (this
by list box, coming from the first form). After that, is it possible to
have auomatically filled the phone/fax fields coming from the first
form after I choosed the company name)?

Bart
Access 2003.

[Br]

AA Arens wrote:

Hello,

Clients database.
I do have two forms accessible from the Switchboard.
The first is to fill in company info.
The second to fill in contact person and the company he works for
(this by list box, coming from the first form). After that, is it
possible to have auomatically filled the phone/fax fields coming from
the first form after I choosed the company name)?

Bart
Access 2003.

Isn't it reduntant to store the phone/fax details in two places? Why not
just look up the details from the CompanyID?
--
regards,

Br@dley

[AA Arens]

I was looking in that directon, but don't know the control scourse.

I have two tables, one consists of company info like name and phone
number.
Another table where I have to fill in the contact persons. Part of the
form is to choose the company he works for (From a list box). Then,
after I choosed the conpany, I want to have auto filled in the field
phone number from the 1st table. But, and that's why i want to have it
archieved in the table (so not double): I want that the field
phonenumber can be editted as the company phone number is not always
the direct number from the contact person.