If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
what is it called to have a drop down list...
I am taking two tables in access and creating a form with two drop down lists. I want to use table 1 data to pull from on the first drop down list and then it should populate the next drop down with the data from table 2. Both tables are linked by a product code. How should I handle this? Maybe I am not doing it the correct way, any suggestions?
Thank U Kim |
#2
|
|||
|
|||
what is it called to have a drop down list...
"kim" wrote in message ... I am taking two tables in access and creating a form with two drop down lists. I want to use table 1 data to pull from on the first drop down list and then it should populate the next drop down with the data from table 2. Both tables are linked by a product code. How should I handle this? Maybe I am not doing it the correct way, any suggestions? Thank U Kim Hi, In my experience, you need to add Me.[listbox2].Requery in the onchange event of the Me.[listbox1] Also, ensure that the query that populates listbox2 has a parameter for the listbox1 determining field. HTH Marc |
#3
|
|||
|
|||
what is it called to have a drop down list...
Here are a couple of KB links regarding synchronizing combo boxes:
How to Synchronize Two Combo Boxes on a Form http://support.microsoft.com/default...b;EN-US;289670 ACC: How to Synchronize Two Combo Boxes on a Form (97624) http://support.microsoft.com/default.aspx?scid=kb;[LN];97624 hth, -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX "kim" wrote in message ... I am taking two tables in access and creating a form with two drop down lists. I want to use table 1 data to pull from on the first drop down list and then it should populate the next drop down with the data from table 2. Both tables are linked by a product code. How should I handle this? Maybe I am not doing it the correct way, any suggestions? Thank U Kim |
#4
|
|||
|
|||
what is it called to have a drop down list...
I am not sure a simply requery would work for you. You may want to use the afterupdate event of Listbox1 to change the rowsource property of Listbox2 using the value of the Listbox1 selection as a filter. When you change the rowsource of a listbox it automatically requeries itself. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|