If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Associate Values with Drop Down Items
I have a drop down list and want those items in the drop down to be
associated with certain values. How can I achieve this? For example: drop down = walk to store - time value would be 1.5 hours. -- The world would be a dark place without light. |
#2
|
|||
|
|||
Do you have a table with fields and records that match your requirement?
-- Duane Hookom MS Access MVP "bzbjg" wrote in message ... I have a drop down list and want those items in the drop down to be associated with certain values. How can I achieve this? For example: drop down = walk to store - time value would be 1.5 hours. -- The world would be a dark place without light. |
#3
|
|||
|
|||
No. All I've done so far is create a combo box, and in the Row Source I
listed my drop-down items. If I create a table and list the items under the Field Name, what is the related Data Type, in order to make this have a time value? "Duane Hookom" wrote: Do you have a table with fields and records that match your requirement? -- Duane Hookom MS Access MVP "bzbjg" wrote in message ... I have a drop down list and want those items in the drop down to be associated with certain values. How can I achieve this? For example: drop down = walk to store - time value would be 1.5 hours. -- The world would be a dark place without light. |
#4
|
|||
|
|||
Your requirement sounds like a simple lookup table with a value/field that
you want to store and then a field to store a related value. -- Duane Hookom MS Access MVP "bzbjg" wrote in message ... No. All I've done so far is create a combo box, and in the Row Source I listed my drop-down items. If I create a table and list the items under the Field Name, what is the related Data Type, in order to make this have a time value? "Duane Hookom" wrote: Do you have a table with fields and records that match your requirement? -- Duane Hookom MS Access MVP "bzbjg" wrote in message ... I have a drop down list and want those items in the drop down to be associated with certain values. How can I achieve this? For example: drop down = walk to store - time value would be 1.5 hours. -- The world would be a dark place without light. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Associate Sent Items with recieved email | HelpPls | General Discussion | 4 | July 7th, 2004 05:00 PM |
average, eliminating zero values | Chris | Worksheet Functions | 6 | May 14th, 2004 11:36 PM |
finding distinct values from two lists | Frank Kabel | Worksheet Functions | 0 | February 14th, 2004 12:41 AM |