By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Entering records into a table from list box values

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.