Add data to table by combo box

[asu81]

Hi!
I would like to enter data in table1 using a combobox as input source. The combo box gets its options (to choose from) from table2.

I've tried setting the combobox record source to table2.xx and its contol source to table1.yy. However this only results in me being able to scroll through the values, but nothing happends when I select a value.

Is this possible?
If not, can it be achieved in some other way?

Thanks!

 

[John Big Booty]

Perhaps this Tutorial will help you.

 

[asu81]

Perhaps this Tutorial will help you.

Thanks, it contained some info I didnt know. It did however not specify how to transfer the chosen info on the combo to the input table, which was my problem

But I realised the probable solution is to make the table field a lookup field type, am I right?

 

[pr2-eugin]

But I realised the probable solution is to make the table field a lookup field type, am I right?

No, Lookup in Table level is not the right answer.. The evil's of lookup are discussed here.. When you set your Control to the Table field, once the data is saved it will be reflected in the table..

 

[asu81]

No, Lookup in Table level is not the right answer.. The evil's of lookup are discussed here.. When you set your Control to the Table field, once the data is saved it will be reflected in the table..

Ok thanks for the warning!
When I tried a second time it worked

The first time I used the expression builder to set the control source to

=[table1]![yy]

That resulted in me being able to see the dropdown list but not pick a value.

the second time I used the dropdown list to just pick a field (yy) among the fields in the table, and that worked

What is the difference between these two ways and why didnt the first one work?

Thx for your time