Cascading combo select issue

[diS]

Hi all!
I searched for this issue but can't find anything that could help.
I am creating simple db for document control.. or honestly I'd like to create it.

DB consist of 3 Tables:
tblCountry
tblState
tblCity

and a Form (frmCity) with cascading combo boxes that allows us to enter new City with existing data.

Combo's are displaying data fine but it don't allow selecting any item.

Shortly, this is what I have done so far:

1. Created cb's: cboContinet, cbo_State and cbo_City

2. Created query's:
a) qryState (added fileds are from tblState- State and Continent)
b) qryCity (fields are from tblCity- City and State)

3. Edit query's: qryState> added criteria for field Continent ([Forms]![FormName]![cboContinet])
I also added criteria in qryCity, field State ([Forms]![FormName]]![cboState])

4. Added VBA on After Update Event:

Private Sub cboDosje_AfterUpdate()
Me.cboGrupa.Requery
Me.cboPredmet.Requery
End Sub

Private Sub cboGrupa_AfterUpdate()
Me.cboDosje.Requery
Me.cboPredmet.Requery
End Sub

Private Sub cboPredmet_AfterUpdate()
Me.cboDosje.Requery
Me.cboGrupa.Requery
End Sub


Macros are enabled in Trust Center and Combo boxes are refreshing fine, but somehow I can't select anything.
Also, I am working with Access 2007 if it matters, I've read something about allowing edits but didn't found how enable them.


Any help would be appreciated.

 

[essaytee]

...snip...
Also, I am working with Access 2007 if it matters, I've read something about allowing edits but didn't found how enable them.


Any help would be appreciated.

In form design view, open the Property Sheet panel, you'll find the setting under the Data tab.

 

[diS]

Thanks, I'll try it.

 

[diS]

Unfortunately it didn't help.
I'll move to Access2013 and hope that version is what caused problem.

Thanks anyway.

 

[jdraw]

There's a video at datapig related to cascading combos.

Good luck. It's older (2003) but concept is the same.