How do I get more than one field from a record?

D

Dave Lawrence

This is probably very simple but it's defeated me! I've
got a table with two fields, one is a name and the other
is a nickname. I've made a form with a combo box which can
select one field and it returns that field ok, but I want
to create a new record which shows both fields from that
record. How do I do this? Thanks.
 
D

Douglas J. Steele

In the combo box's AfterUpdate event, you can put code to refer to the
individual columns in your combobox.

Me.MyCombo.Column(0) will give you the value in the first column of the
selected row, while Me.MyCombo.Column(1) will give you the value in the
second column of the selected row.
 
Top