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

"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

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

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/