Select Two Values from One Combo

[Chris Freeman]

I have a form that has a combo box, that allows users to select a mailing
date listed in a table. works just fine, but now, the users need to see both
the Holder ID and Date. I can show both in the combo box, but the selection
process selects only allows one field value to be returned. Plus, I'm
grouping by dates to return unique date value for each Holder, as there can
be multiple letters mailed on that date for each Holder.

Is there a programming work aorund that would idenitify both values?

 

[Jeanette Cunningham]

Hi Chris,
to get the date for the selected holder id, use-->
Me.NameOfCombo.Column(1),
assuming that the date is in the second column of the combo.

Combo columns are numbered starting with zero for the first column.

To get the value for any column other than the first, you use
Me.NameOfCombo.Column(n),
where 'n' is the number of the column.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Chris Freeman]

Jeanette,
Perfect, I figured it was something like this, but was leaving off the
Column. Duh! Thanks for the mentoring.
--
Chris Freeman
IT Project Coordinator

Hi Chris,
to get the date for the selected holder id, use-->
Me.NameOfCombo.Column(1),
assuming that the date is in the second column of the combo.

Combo columns are numbered starting with zero for the first column.

To get the value for any column other than the first, you use
Me.NameOfCombo.Column(n),
where 'n' is the number of the column.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia