By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,658 Members | 1,612 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,658 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Feb 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Feb 19 '06 #2

P: n/a
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.

Feb 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.