S
SteveS
Use your control names and form names...
With the controls on the same form:
Me.TextBoxName = Me.ComboBoxName.Column(X) where X is the
column count minus 1 (columns are zero based). So, if
there are two columns, then use Me.ComboBoxName.Column(1)
With the text box on a different form:
Forms!FormName!TextBoxName = Me.ComboBoxName.Column(X)
You can connect it however you want!!!! <grin>
HTH
Steve
With the controls on the same form:
Me.TextBoxName = Me.ComboBoxName.Column(X) where X is the
column count minus 1 (columns are zero based). So, if
there are two columns, then use Me.ComboBoxName.Column(1)
With the text box on a different form:
Forms!FormName!TextBoxName = Me.ComboBoxName.Column(X)
You can connect it however you want!!!! <grin>
HTH
Steve