Entering records into a table from list box values

mike

Hi All

I have a listbox which has a table as its row source. I want to be able
to choose from this listbox (which has approximately 8 records) and
have this value entered into another table (it currently has a field
from this table as its control source but this doesn't seem to help). I
am also having problems with retaining the value on the form - if I go
back through the records on the form it will overwrite the previous
values with the last chosen value (not sure why this happens).
Ultimately each record will have a designated value from the listbox.
Any thoughts on this would be appreciated - I'm no expert on Access so
I hope I've explained it coherently enough.

Cheers,
Mike

Nov 13 '05 #1

ego

Hi Mike,

As I understand you have a List box that is based on a table.

You want to choose from the List box a value and then save this value
in a different table.
Try The following:

1. Make sure that on the second table (The table that you want the
value to be saved) there is a Text field , for example : strList ---
type of the field : Text.

2. Create a Form based on the second table.

3. Create a list box and the follow the wizard

4. Choose option 1 : "I want the List box to look up values in a
table or query"

5. Choose the table that the Listbox is based on.

6. Choose the field that you want to see.

7. Press next and again next.

8. Choose " Store that value in this Field" , and select the
strList field.

This should do the job.

Hope that help.

Ego

Nov 13 '05 #2

Bas Cost Budde

mi**@geographx.co.nz wrote:

I have a listbox which has a table as its row source. I want to be able
to choose from this listbox (which has approximately 8 records) and
have this value entered into another table.

If you bind the listbox to the destination table field, it seems to me
all is done. That way you will overcome the navigation problem as well.

The property you want to set is called ControlSource.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

Nov 13 '05 #3