Hi,I'm having some trouble, I have two cascading combo boxes, the first filtering the results for the second.

When I add new data to the subform or either table, the new categorized aren't added to the combo boxes. I have been working on a requery with the code

Option Compare Database

Private Sub Form_AfterUpdate()
Me.Parent!productgroup.Requery
Me.Parent!cboRowField.Requery
Me.Parent!cboColoumnField.Requery
End Sub

This is not working. So...is this the right code or am I even entering the data in the right area's. And The code above is for the subform, should it be somewhere else. My whole application is based off the 7th Example down on this page entitled "Cascading Combo Boxes Data Base" http://www.candace-tripp.com/utterangel.aspx.

Any help is greatly appreciated.



Cheers