SetValue or ???

[Neal0o via AccessMonster.com]

have a Combo Box with 3 columns; the 1st with the classID, the 2nd with the
Class title, and 3rd ClassTime. When I click on the selected LastName to
store it for printing I would also like to be able to select and store, with
that one click, the FirstName. In the "Click" line "in the "Property" for
that Combo" I have entered the
name of a Macro which I though could use the "SetValue" to store the data,
but how can I define (express) the 3rd column of the Combo. In any case is
that the correct way to go about.

Found this reply on another site but can't get it to work.

You could have a visible text box on the form called txtFirstName
and set its control source property to =YourCombox.Column(1)

in this case when i enter =TRAINING COURSE 1.Column(3) it doesn't work. can
someone please help?

Thanks a million
Neal

 

[Douglas J Steele]

The Column collection starts at 0. To refer to the 3rd column, you need to
use Column(2)

 

[Neal0o via AccessMonster.com]

The Column collection starts at 0. To refer to the 3rd column, you need to
use Column(2)

have a Combo Box with 3 columns; the 1st with the classID, the 2nd with the
Class title, and 3rd ClassTime. When I click on the selected LastName to

[quoted text clipped - 15 lines]

Thanks a million
Neal

Thanks!!!