combining different drop down fields in one record into one field

[Nancy]

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?

 

[Al Camp]

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)

 

[BruceM]

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
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).
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]

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!

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

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?

 

[Al Camp]

Nancy,
Check out what Bruce has posted.
If you still have problems, or you have specific questions, post back on this thread.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

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!

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

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?