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

Transfer data from one list box to the other

P: 18
I am designing a database prototype for my senior design class, and there are is a problem that I don't have any idea about where to even start. So, anybody out there, I will highly appreciate if you can take some of your precious time to help me out.

Consider I have a list box with three attributes (State, Region, and City) of an entity called Country. I should be able to select one or more than one of these attributes and there values should show up in another list box. These values may be repeated, but I only want unique values in the list box. For example for State there might be two entries: New York and New York, but I only want to see one entry in the second list box. Again, I should be able to select one or more than one of these values from the second list box and the corresponding country name should show up in the third list box. For example if I select New York and California from the second list box, than the corresponding country names which are stored in the table "Country" should show up in the third list box.

I look forward for some help.

Thank you
Mar 13 '08 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Have a look at this tutorial on Cascading combo/listboxes. You will need to adapt the query for the row source of the second listbox slightly. Something like ...

.RowSource = "SELECT DISTINCT [" & Me!List0 & "] " & _
"FROM Country "

...where List0 is the name of the first listbox
Mar 14 '08 #2

NeoPa
Expert Mod 15k+
P: 31,489
You refer obliquely to multiple selections in your listboxes. Are you talking about multi-select listboxes?

Can you confirm that the fields that are included in the selection process are [Country], [Region], [State] & [City]? Presumably all fields in your [Country] table.

I'm having big trouble understanding your comment :
Consider I have a list box with three attributes (State, Region, and City) of an entity called Country. I should be able to select one or more than one of these attributes and there values should show up in another list box.
Is this three columns that are visible in a single ListBox?
How would it be possible to select an individual column in a ListBox?

I'm sure I have the wrong end of the stick somewhere, but that's what your post says so perhaps you could clarify a little.
Mar 15 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.