Referencing a value from a Combo Box

[LOUISBUHAGIAR54]

Can someone please remind me how to reference a value on a combobox in one form from an object on another form.

I have put in =Forms![Company Name].Combo7 in the field object on the form and I have got the ID autonumber of the Company Name. So far so good. It worked.

When I put in =Forms![Company Name].Combo7.column1 to get the company name to appear in the field I got an error.

What is the correct entry that needs to be entered? many thanks.

 

[pbaldy]

Close; try

=Forms![Company Name].Combo7.column(1)

 

[LOUISBUHAGIAR54]

I TRIED THAT AND IT WORKED FINE. tHANKS FOR YOUR ASSISTANCE

 

[pbaldy]

No problem.

 

[LOUISBUHAGIAR54]

Thanks. Well done.