lucyLuna
asked on
Drop down list synchronization
Hello,
I have created three drop down lists, one for Year, one for Make ("Manufacturer), and one for Model, as pertaining to the Auto Industry.
Each lists has a lookup field (Year, Make and Model Tables)
My problem is how to syncronize data, for example I want to see that each drop down shows only data which is related...is there a way to do VBA code to sychronize all three lists?
I have limited experience with VBA, but can copy and paste code.
Thanks much
I have created three drop down lists, one for Year, one for Make ("Manufacturer), and one for Model, as pertaining to the Auto Industry.
Each lists has a lookup field (Year, Make and Model Tables)
My problem is how to syncronize data, for example I want to see that each drop down shows only data which is related...is there a way to do VBA code to sychronize all three lists?
I have limited experience with VBA, but can copy and paste code.
Thanks much
Here is a simple description of linked (cascading) combo boxes:
cboSelectCustomer has tblCustomers as its row source. Its AfterUpdate event sets cboSelectOrder to Null or "", and requeries cboSelectOrder.
cboSelectOrder has tblOrders as its row source, with a criterion of [Forms]![frmSelectOrder]![ cboSelectC ustomer]
(and so forth for as many combo boxes as you need)
cboSelectCustomer has tblCustomers as its row source. Its AfterUpdate event sets cboSelectOrder to Null or "", and requeries cboSelectOrder.
cboSelectOrder has tblOrders as its row source, with a criterion of [Forms]![frmSelectOrder]![
(and so forth for as many combo boxes as you need)
ASKER
Thanks to everyone...I am still working with the options offered, seem like lots of code editing to get this right....I am going to try Helen_Feddema solution....sometime today.
I am looking for something simple..Thanks Helen, I will let you know how your solution works out.
Lucy
I am looking for something simple..Thanks Helen, I will let you know how your solution works out.
Lucy
ASKER
Thanks to all of you....but I am still in the dark about how to solve this problem, when I try to use code provided in solutions...I just get more confused! does anyone have an example related to the auto industry? re-writing code to match my needs is a challenge for my skill level.
Thank again.
Lucy
Thank again.
Lucy
ASKER
I have somewhat found a solution...although I lost over25,000 records, I only have 43 records but, in order to move forward...or until I find a real solution....I would like to know if anyone can help me with "not in list event" my users will have type in the info I lost (25,000 records).
I would like for users to add "year, make and model" in each respective Combo Box, I am not sure how to go abou this, coding seems a huge challenge to me.
your help is truly appreciated.
I would like for users to add "year, make and model" in each respective Combo Box, I am not sure how to go abou this, coding seems a huge challenge to me.
your help is truly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@LukeChung, I was able to find missing records by;
creating one table with ID, Year, Make, Model fields
...then, I did lookup for each of the values on my main form
The form pulls data from main table,
Then I created three combo boxes (year, make, model) on the form...and now I see all records.
However, I need the user to be able to add cars not on the list...I have opened another question for this issue.
Thanks...but the way I configured the Year, Make and Model (as explained above) may not be be set up properly...and I am still waiting for someone to offer a better solution, or to let me know that the way I set it up is fine, and I won't have problems with it.
Lucy
creating one table with ID, Year, Make, Model fields
...then, I did lookup for each of the values on my main form
The form pulls data from main table,
Then I created three combo boxes (year, make, model) on the form...and now I see all records.
However, I need the user to be able to add cars not on the list...I have opened another question for this issue.
Thanks...but the way I configured the Year, Make and Model (as explained above) may not be be set up properly...and I am still waiting for someone to offer a better solution, or to let me know that the way I set it up is fine, and I won't have problems with it.
Lucy
ASKER
Thank you very much.
Candace Trip (Utter Angel) has an example
Cascading Combo Boxes Database (Click Here)
Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes in a cascade.