472,791 Members | 1,114 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,791 software developers and data experts.

Entering records into a table from list box values

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.


Nov 13 '05 #1
2 12300
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.


Nov 13 '05 #2
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

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: tom | last post by:
I am new to SQL administration. >From a list of IDs that are the primary key in one table (i.e. Customer Table), I want to make changes in tables that use those IDs as a foreign key. ...
by: Robin S. | last post by:
**Eric and Salad - thank you both for the polite kick in the butt. I hope I've done a better job of explaining myself below. I am trying to produce a form to add products to a table (new...
by: Nhmiller | last post by:
When I start to type the data for a new record, I would like a dropdown box to open next to it from which I can choose the data from a previously entered record that starts with the same letter....
by: Ian Davies | last post by:
Hello Needing help with a suitable solution. I have extracted records into a table under three columns 'category', 'comment' and share (the category column also holds the index no of the record...
by: redstamp | last post by:
Try as I might I cannot find a way to write an access query to return a result set with the records from my database WITHOUT a certain set of values within a field. To explain, I have a table of...
by: Dave | last post by:
On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...
by: chumlyumly | last post by:
Hello scripters - OS: Mac OSX Language: PHP w/ MySQL database I've created an insert page where a user inputs his info, which then goes to four different tables in a MySQL database. The...
by: phopman | last post by:
Hi there! Since this is my first post, I'll try to be gentle with you :-) I have a script that goes like this: Connect to db. select data from db, and list up (only one variable, text). I...
by: Clint Schaefer | last post by:
Apologies in advance. I've seen similar questions, but none of the solutions seem to be working for me... I have a form that allows a user to select mutiple items (payroll deduction codes) in a...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.