list box multiple options 1

[dvetro]

Hello,
I am trying to create a simple list box combo. For instance, I have a list box call state in a form, in this I have values that I have entered. I also have a combo box called city. What I would like to do is populate the city box based on what is in the state box.

i.e. I tab to the state box and select TX, I would then like my city box to reflect the cities in TX and list them in the list box, such as Houston, Dallas, El Paso. If the state is NE, then list Omaha, Lincoln and so on. I am lost on how to do this. Any help would be greatly appreciated.

Thanks in advance

 

[jfgambit]

I have an example if you want me to send it to you, but basically...

1. Create the listbox called lstState based off the State Table

2. Create the Combobox called cboCity with the following as the RowSource:

SELECT [tblCity].[City], [tblCity].[State] FROM tblCity WHERE ((([tblCity].[State])=[Forms]![frmStateCity]![lstState]));

3. Add the folowing to the On Click event of the Listbox:
Me.cboCity.Requery

Ta-da....



"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[dvetro]

That works, thank you very much.

 

[dswitzer]

Hey Vetro -- is that you clogging up the bandwidth with inane questions?