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

  • Thread starter Thread starter Dave Lawrence
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting more than one field from a record 1
one record 10 fields to ten rcords 1 field 6
More Than One Field Query 2
Populate combo box from current record 3
Calculated field in a table 6
Appending records to new table using field names as values 2
How to create a new field from other record fields in a table 5
From a Form subtract issue from bound QtyOnHand in a new record 1

Back
Top