Fill a subform field from a combo box

[dr223]

Hi,

I have two forms, the main form called stud_details which contains a subform called pay_det_sub.

The second form is called payr_lkup_name which has a combo box for the look up called cbopyrname.

What i want to is when the payer name is selected it adds the payer name to the subform which has a field called txtpayer_name...

I have tried this code it is not working ....

Forms!stud_details!pay_det_sub.Form.txtpayer_name = Me.cbopyrname(col1)

any help please

 

[Alisa]

How about this?

Forms!stud_details!pay_det_sub.Form.txtpayer_name = Me.cbopyrname.column(1)

 

[dr223]

Thank you very much Alisa, worked perfectly...

 

[Alisa]

you are welcome