Combo Box Query

[Guest]

I can create a combo box to select a field value eg, Regions

The field value has a number of sub categories eg, Cities in the Region

How can I create another field that will allow me to select only the cities
associated with the selected region.

RegionA: Cities L,M,N,O or P
RegionB: Cities W,X,Y or Z

 

[Douglas J. Steele]

Check the following:
http://support.microsoft.com/?id=209595
http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx
http://www.mvps.org/access/forms/frm0028.htm

 

[Guest]

Assuming that cboRegion lists all the regions and cboCity - all the Cities
related to the selected Region.
Private Sub cboRegion_AfterUpdate()
Me.cboCity.RowSource = "SELECT City_Id,Name FROM tblCities Where
Region_Id = " & Me.cboRegion.Column(0) & ";"
Me.cboCity.SetFocus
Me.cboCity.Requery
End Sub