Write to a table from a form

[scorpio_x73]

a have a form with a combo box that displays 3 values (columns)

in a bound form i can display the second value in a text box with the following command
=Forms!MAIN!field_2.COLUMN(1)

but i can't write it to the table

my main table has 3 fields

field_1
field_2
field_3

i have a secondary table that holds some values and is been used as a lookup list to field_2

my secondary table has 3 fields

field_a
field_b
field_c

the field_2 of main table takes value from field_a (the lookup list shows all the fields (a,b,c) and i want in text field lets say field_3 to take the value of field_b with this code
Forms!MAIN!field_2.COLUMN(1)

The problem is that i want the value of Forms!MAIN!field_2.COLUMN(1)
to be written to a field of the main table and i cant


Thanks in advance

please help me

 

[Rickster57]

form

Let's say you have a form called form1. On this form you have 2 bound text boxes called text1 and text2. Also, the form has a combo box called combo1 with columns ID,Name,Address. If you want text2 to get the address value from the combo box that you choose then place me.text2=me.combo2.column(2) in the After Update Event of the combo box.

Hope this helps

 

[scorpio_x73]

Thank You !!!!!!!!!

Let's say you have a form called form1. On this form you have 2 bound text boxes called text1 and text2. Also, the form has a combo box called combo1 with columns ID,Name,Address. If you want text2 to get the address value from the combo box that you choose then place me.text2=me.combo2.column(2) in the After Update Event of the combo box.

Hope this helps

Thank you 1000 times. It works superb.

Again Thanks you for your time and answer