combining different drop down fields in one record into one field

I have a table with 5 fields, each of which are drop down. I need to combine
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13242-combining-different-drop-down-fields-one.html
the five fields in each record into one field for that record. I then need
the entire record to be one drop down field. Is this possible? For example,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
my fields are "event, venue, date, time, parking". Can they be combined so
that all those fields are in one field, so that my info in the record will be
"Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
down field so that all events come up and can be chosen as one field?

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Nancy,
The data can be concatenated from the values you already entered.
In an unbound text control use this Control Source...
(use your own field names)
= [Performer] & "/" & [Venue] & "/" & [EventDate] & " " & [EventTime] & "/" & [Parking]

Since you've already "captured event, venue, date, time, parking to your table, there's
no need to also save that to another field after you've concatenated the values. Just
"display" the concatenation.
The concatenation can always be re-derived "on the fly" in any subsequent form, query,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
or report. Just the way we did it above.
And... it can also be concatenated into the first column of your combo box for
selection purposes.

(although... you really should be using an EventID key field value for your combo
selection, with the concatenation only there to assist the user in identifying the proper
event)

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Nancy" wrote in message
news716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
>I have a table with 5 fields, each of which are drop down. I need to combine
> the five fields in each record into one field for that record. I then need
> the entire record to be one drop down field. Is this possible? For example,
> my fields are "event, venue, date, time, parking". Can they be combined so
> that all those fields are in one field, so that my info in the record will be
> "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
> down field so that all events come up and can be chosen as one field?

To expand a bit on what Al has written: You can combine the fields in the
combo box row source. What follows assumes you have a primary key field.
You can create a primary key that combines several fields, but a single
field (autonumber, for instance, or any other unique identifier) will
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
simplify things. One way to accomplish your intention is to use the combo
box wizard. Be sure the magic wand icon is highlighted in the toolbox,
click the combo box icon, and click the form to insert the combo box. When
the wizard starts, select the option that begins "Find a record...", and
click Next. Move the primary key field only to the right hand box, and
click Next. Add the label name, and click Finish. Click the combo box to
select it, then click View > Properties. Click the Data tab, then click the
Row Source line. Click the three dots, which will open a query design grid.
In the second (empty) column put something like:
AllInfo: [NameField] & "/" & [DateField] & "/" etc. (use your actual
field names).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
Use the third (and subsequent columns as needed) to add fields by which you
wish to sort the records. Click the Sort row and make your choice.
You don't need to store the combined field. In fact, you shouldn't. It
will be calculated as needed.

"Nancy" wrote in message
news716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
>I have a table with 5 fields, each of which are drop down. I need to
>combine
> the five fields in each record into one field for that record. I then need
> the entire record to be one drop down field. Is this possible? For
> example,
> my fields are "event, venue, date, time, parking". Can they be combined
> so
> that all those fields are in one field, so that my info in the record will
> be
> "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
> down field so that all events come up and can be chosen as one field?

Oh my goodness - thank you! I'm a beginner though, and not smart enough to
know what you are talking about. I'll try to figure it out though. I've
come this far on my own so maybe I can make it all work. Thanks so much!

"Al Camp" wrote:

> Nancy,
> The data can be concatenated from the values you already entered.
> In an unbound text control use this Control Source...
> (use your own field names)
> = [Performer] & "/" & [Venue] & "/" & [EventDate] & " " & [EventTime] & "/" & [Parking]
>
> Since you've already "captured event, venue, date, time, parking to your table, there's
> no need to also save that to another field after you've concatenated the values. Just
> "display" the concatenation.
> The concatenation can always be re-derived "on the fly" in any subsequent form, query,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
> or report. Just the way we did it above.
> And... it can also be concatenated into the first column of your combo box for
> selection purposes.
>
> (although... you really should be using an EventID key field value for your combo
> selection, with the concatenation only there to assist the user in identifying the proper
> event)
>
> --
> hth
> Al Camp
> Candia Computer Consulting - Candia NH
> http://home.comcast.net/~cccsolutions
>
> "Nancy" wrote in message
> news716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
> >I have a table with 5 fields, each of which are drop down. I need to combine
> > the five fields in each record into one field for that record. I then need
> > the entire record to be one drop down field. Is this possible? For example,
> > my fields are "event, venue, date, time, parking". Can they be combined so
> > that all those fields are in one field, so that my info in the record will be
> > "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
> > down field so that all events come up and can be chosen as one field?
>
>
>

Nancy,
Check out what Bruce has posted.
If you still have problems, or you have specific questions, post back on this thread.
--
hth
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Nancy" wrote in message
news:594EF3A2-CDC5-4AC5-B443-2B69F388DF52@microsoft.com...
> Oh my goodness - thank you! I'm a beginner though, and not smart enough to
> know what you are talking about. I'll try to figure it out though. I've
> come this far on my own so maybe I can make it all work. Thanks so much!
>
> "Al Camp" wrote:
>
>> Nancy,
>> The data can be concatenated from the values you already entered.
>> In an unbound text control use this Control Source...
>> (use your own field names)
>> = [Performer] & "/" & [Venue] & "/" & [EventDate] & " " & [EventTime] & "/" & [Parking]
>>
>> Since you've already "captured event, venue, date, time, parking to your table,
>> there's
>> no need to also save that to another field after you've concatenated the values. Just
>> "display" the concatenation.
>> The concatenation can always be re-derived "on the fly" in any subsequent form,
>> query,
>> or report. Just the way we did it above.
>> And... it can also be concatenated into the first column of your combo box for
>> selection purposes.
>>
>> (although... you really should be using an EventID key field value for your combo
>> selection, with the concatenation only there to assist the user in identifying the
>> proper
>> event)
>>
>> --
>> hth
>> Al Camp
>> Candia Computer Consulting - Candia NH
>> http://home.comcast.net/~cccsolutions
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13242
>>
>> "Nancy" wrote in message
>> news716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
>> >I have a table with 5 fields, each of which are drop down. I need to combine
>> > the five fields in each record into one field for that record. I then need
>> > the entire record to be one drop down field. Is this possible? For example,
>> > my fields are "event, venue, date, time, parking". Can they be combined so
>> > that all those fields are in one field, so that my info in the record will be
>> > "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
>> > down field so that all events come up and can be chosen as one field?
>>
>>
>>