Combo box

G

gizmogwaisan

Guest

• Nov 18, 2002

• #1

Please help me...

I have two tables, City and State. In CITY table-CityID as Primary Key and StateID as foreign key. State ID is the primary kay of STATE table. I want to have 2 combo box in my form, one for STATE list and another for CITY. How should I do it so that when I choose eg. State1 in the first combo box, the second combo box will display only the city in State1.

Thanks in advance.

 

boblarson

Smeghead

Local time

Yesterday, 18:03

Joined

Jan 12, 2001

Messages

32,040

• Nov 18, 2002

• #2

This is how I do it in one of my databases.

1. In the ON CHANGE of the State combo box, I put code to set the rowsource of the city combo box to a SQL statement (or you could set up a query) that selects those cities that belong to that state.

2. then I use the requery (cmbCity.Requery) to update the city box.

 

andreas_udby

Registered User.

Local time

Today, 02:03

Joined

May 7, 2001

Messages

76

• Nov 26, 2002

• #3

Bob,

I'm trying to do something similar. Could you send me that code? awu2@cornell.edu

Thanks,
Andreas

 

Oldsoftboss

AWF VIP

Local time

Today, 13:03

Joined

Oct 28, 2001

Messages

2,499

• Nov 26, 2002

• #4

Bit of info for everybody
Dave

 

Attachments

• db7.zip

  63.1 KB · Views: 180