Populate a text field from a combo box

[mtabt]

I have a form that contains a combo box (RCNAME) and a text field (RC#). A RCNAME uniquely corresponds to a RC#. I want my users to choose a RCNAME from the combo box and automatically get the corresponding RC# in the RC# field.

How do I do this.???

Please help. Thank you very much in advance.

 

[JoeMiller]

See this thread: thread702-82768 Joe Miller
joe.miller@flotech.net

 

[Aivars]

Sub RCNAME_AfterUpdate()
RC# =RCNAME
or
RC# =RCNAME.column(ComboBoxColumnNumber) '>>> ComboBoxColumnNumber of first ComboBox column = 0

end sub

Aivars