How to pass the variable into the form

[Steven]

Hi, I have 2 combo box (A and B) in a form.

The first combo box (A) is to select record from the table. After the
user selected the appropriate record, it will display in the form.

If the user discover an error in the material column and would like to
change to the correct material, he will select the second combo box (B)
and select the material from the list.

The first combo box (A) is use for selection for table A and the second
combo box (B) is use for selection for table B.

I've no problem for the first combo box but for the second combo box,
it cannot pass the variable from combo box (B) to the form.

Can anyone please advise on the code??

 

[Dennis]

Surely the material should be a field in table A and you are simply using
Table B as a look up list for valid materials ?
In this case Combo B is a bound field to your form anyway.
If this is not the case, explain what you mean by 'pass the variable to the
form'
because if you select a material from a combo on a form then it is in that
combo box name on the form.