[AccessD] FW: Store value on form to table

Not sure exactly what you are doing but have a look at these sample 
mdb's especially cascading combo boxes and listboxes.
And this one
MultiSelect.mdb ( intermediate )
Form illustrates two methods how to write values selected in a 
multi-select list box into a table.

http://www.rogersaccesslibrary.com/TableOfContents3.asp

Might be enough to get you started.

Kaup, Chester A wrote:

>I made a misstatement in my original question. The building of the list
>box is giving me the list of fields that are the record source of the
>form. The values from the list box are not getting stored though. Why?
>
>Chester Kaup
>Information Management Technician
>IT-MidContinent/MidContinent Business Unit
>CTN 8-687-7415  
>Outside 432-687-7414
>
>No trees were killed in the sending of this message. However a large
>number of electrons were terribly inconvenienced. 
>
>
>
>  
>
>> -----Original Message-----
>>From: 	Kaup, Chester A  
>>Sent:	Tuesday, June 22, 2004 9:43 AM
>>To:	AccessD at databaseadvisors.com
>>Subject:	Store value on form to table
>>
>>I have two questions regarding storing a value on a form to a table.
>>I have a text box on a form that gets its value from a selection made
>>on another form.
>>I also have on the same form a drop down list box. When I created the
>>list box I picked the selection to store that value in this field but
>>that only gives me a list of fields in the query that is the source
>>for the list box. I need to store the contents of the text box and the
>>selection from the drop down list box to a table. I am having no
>>success doing this. Your help in doing this would be appreciated.
>>
>>Chester Kaup
>>Information Management Technician
>>IT-MidContinent/MidContinent Business Unit
>>CTN 8-687-7415  
>>Outside 432-687-7414
>>
>>No trees were killed in the sending of this message. However a large
>>number of electrons were terribly inconvenienced. 
>>
>>
>>
>>    
>>

-- 
Marty Connelly
Victoria, B.C.
Canada