how to insert the value from combobox in a table

[neelesh kumar]

sir,
i have 2 tables namely tblexam and subject.
in tblexam fields r questionno,subcode,question,options and answer.
in subject table fields r subcode,subname.
i created form using wizard from tblexam taking all the fields except subcode.
in the form i created a combobox for subname from the subject table.
when i select some subname in the form ,.that subcode from the subject table has to be inserted in the tblexam subcode field.how can i do this
thanks in advance.

[Rabbit]

Set the control source of the combobox to subcode.

[neelesh kumar]

my combobox name is combo69.i have a table named tblexam.
i want to insert the value of combobox into the tblexam subcode field.
tblexam consists of questionno,question,subcode,options fields.
combobox is designed from subject table to lookup the values in table consisting of subname,subcode fields.
i wrote the code as
private sub combo69_afterupdate()
subcode = DLookup("subcode", "Table3", "[subname]= '" & Combo69 & "' ")
DoCmd.RunSQL "update tblexam set tblexam.subcode= 'subcode' where questionno = Me.questionno"

the code is not working
please help me

[Rabbit]

No need for code, just set the control source property of the combobox to subcode.