Update a Form Field

[Tony Johnson]

Hello,

I have a form that has a lot of fields. It is based on a one table. I
have company information and then a description. I have to continually
type in the description and it is a duplication of work because I have
the description written in another table. I want the description field
to be updated automatically so I dont have to keep typing it in for the
particular vendor. I can build a query but it would affect other
reports and forms because I would have to change them too.

Is there some kind of code that will automatically populate the
description field with the description from another table without having
to build something?

I am on OK user of access but dont know VBE.

Thank you,
TJ
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Rick Brandt]

"Tony Johnson" <et*@wt.net> wrote in message
news:3f*********************@news.frii.net...

Hello,

I have a form that has a lot of fields. It is based on a one table. I
have company information and then a description. I have to continually
type in the description and it is a duplication of work because I have
the description written in another table. [snip]

Ok let's stop here. You're close to doing this properly because you have
recognized that you shouldn't have to enter the Company Description
redundantly. What you don't yet see is that you shouldn't even be
*storing* it redundantly. The proper thing to do here is NOT to
automatically make a redundant entry, but rather use a lookup to the second
table so that this entry is eliminated entirely.

All you should be storing about companies in this second table is the
Company key field. All other data *related* to the company should be
retrieved from the lookup table and not redundantly stored in other tables.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Troy]

Hello,

This is a late reply but maybe you still are following. You said to
make a look up field for the field that I want to have updated from
another table. I did that and it updated to current data but it does
not update for anything later. Do you happpen to know why it will not
update after making the lookup field in the table?

YOU SAID:
Ok let's stop here. You're close to doing this properly because you have
recognized that you shouldn't have to enter the Company Description
redundantly. What you don't yet see is that you shouldn't even be
*storing* it redundantly. The proper thing to do here is NOT to
automatically make a redundant entry, but rather use a lookup to the
second table so that this entry is eliminated entirely.

All you should be storing about companies in this second table is the
Company key field. All other data *related* to the company should be
retrieved from the lookup table and not redundantly stored in other
tables.

Thank you
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!