text box defalt to second line from a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box that I would like the default to be the second (2)
line from a combo box. The combo box holds three lines (name, street
address, city state zip) The are linked to one field in a table, not 3. So I
need to pull out the 2nd line. Thank you
 
Using the word line I think might be confusing. I believe what yo mean to
say is Column. In the example below, note that the column number reference
is 1. That is because column references for combo boxes are zero based, so
the first column is 0, the second is 1, and the third is 2.

Put this in the After Update event of the combo box:

Me.txtSecndLine = Me.cboMyCombo.Column(1)
 
Hi Klatuu
The combo box is linked to text box that the enter key goes to next line in
field. so I enter the "name (enter) address (enter) and city state zip (tab)
to next field.
 
Back
Top