Show multiple fields in combo box

[Guest]

Hello,

I would like to list up to 5 separate date fields (eg. - Expiration Date,
Feasability Date, Effective Date, etc.) in a combo box. These fields are in
the table upon which my form is based. Help!

Lisa

 

[Rick B]

Did you try searching for an answer? I found a bunch of previous posts...

http://groups-beta.google.com/groups?q=microsoft.public.access+combo+multiple+fields

 

[Lee Stafford via AccessMonster.com]

In the Data Tab of the Properties box, set the Row Source Type to
"Table/Query" and the Row Source to the table that has your values.

Then in the Format Tab of the Properties box, set the Column count to the
number of fields that you want to display. Set the Column widths to
1";1";1";1";1" and so on.

The box must be bound to a column in that table. This is set in the Data
Tab, bound column.

I hope this helps.

Lee S.

 

[Guest]

Hi Lee,

Thanks for your advice. I'm afraid, though, that I didn't make myself
totally clear. What I need on the combo dropdown is essentially an "or"
setup. Choose this date, or that date, or that one. Those dates, as I
mentioned, are in the table. So I am looking for a vertical list of 3 or 4
different date fields from the current record. The user chooses one of them,
and then it does some math with the date (which Rick B helped me with awhile
back

Thinking out loud here, will those 3 or 4 dates entered prior to tabbing to
the combo box even show up in the combo box if the record hasn't been updated?

Thanks in advance -

Lisa