transferring multiple columns from combobox to fields on a form

[Guest]

Hello i am a newbie to access and want to find out if there is a simple
straight forward way of transferring multiple columns from a combobox to
various fields on a form. I know transferring one entry from a combo box to a
field is easy using wizards. Is there any way to do the same for multiple
entries on to multiple fields. For example lets say i have a record with 3
columns in a combobox: date, time, name. I want to select the record in the
combobox and transfer those details to 3 labels in a form. Hope this makes
sense. Seeing as i am a newbie only been using access for a week now I would
like to try and do this without using vb! A full detailed explanation of the
procedure would be great too. Many thanks )

 

[Guest]

You can refer to the combo box columns as the "Control Source" for a tex box


=ComboName.column(0)
=ComboName.column(1)
=ComboName.column(2)
=ComboName.column(3)
=ComboName.column(4)

Note that the "1st" column in a combobox is column 0, the 2nd is column 1,
the 3rd is column 2, etc.

Hope this helps