Adding information based on the entry of another field

[Lyndon000]

Hi guys,

I have a form that has a combo box which contains contact names from a form.

Once that is updated I want to autopopulate the company they work for which is a field in the same table on the same row as the contacts names.

I am a noob to all this so was wondering if there is a way to do this?

 

[CJ_London]

You'll need to be clearer about what you want to do, your table structure and the recordsource to your form(s?)

 

[David R]

Rather than storing the company name in two places, you can add it as a (hidden, if necessary) column in your combobox. Then you can set an unbound control to display it with =Me.combobox.Column(2) (or whatever number it actually is).

Storing it in two places will lead to data inconsistency, duplication of effort, and heavy drinking. Google normalization for more information.