Combo Box ?

[tiger]

Hi,

I have two combo box on a form and I was wondering if there is a way for me
to use the top combo box to determine the content of the 2nd combo box. i.e
if the top combo box content is TVand Radio. If the user select TV, then
the content of the second combo box will be list of TV stations and if the
user selects Radio the content of the second combo box will be Radio
stations.

Thanks
Tiger

 

[Larry Linson]

Yes. Include the value of the first Combo Box in the Criteria of the
RowSource of the second ComboBox and Requery the Second ComboBox in the
AfterUpdate event of the first Combo Box. I generally "force" the order by
not Enabling the second Combo Box until the AfterUpdate event of the first
one.

Larry Linson
Microsoft Access MVP

 

[Guest]

Perhaps, you could insert the selected value from your first combo box into a
table and create a query that looks up that value and returns the desired
result as the data source for your second combo box.

 

[Guest]

Hi Tiger,

To add to the idea that Larry Linson gave you, here is a Microsoft KB
article that gives you step-by-step directions for creating a synchronized
combo box:

How to synchronize two combo boxes on a form in Access 2002 or in Access 2003
http://support.microsoft.com/?id=289670


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi,

I have two combo box on a form and I was wondering if there is a way for me
to use the top combo box to determine the content of the 2nd combo box. i.e
if the top combo box content is TVand Radio. If the user select TV, then
the content of the second combo box will be list of TV stations and if the
user selects Radio the content of the second combo box will be Radio
stations.

Thanks
Tiger