Cascading Comboboxes update problem!

[A|ex]

ive got a problem with my Cascading Comboboxes, they work fine and update to whatever thing you choose. HOWEVER on my LAST level of combo boxes ive got several numbers listed based of product.
Whatever product i choose first the numbers after will be the same for ALL other products. It doesnt seem to relookup the numbers, it only looks them up for the first value only. how do i fix it so it looks up EVERYTIME the parent option is chosen?

 

[WayneRyan]

Alex,

It sounds like you are not requerying your combo, but I need more information
to figure that out.

Wayne

 

[A|ex]

all i am using atm is the combo box in the F&Q all ive done is rename the field names added ONE more level to it thats it. What should the even procedure on the field be? After Update?

It works on the current record but as soon as you change to record 2 its the same for the LAST field. the other 2 above are fine

 

[WayneRyan]

Alex,

The combo-boxes are just the means to find your records. As you move
about the recordset, you're not expecting the combos to change are you?

Need more info here.

Wayne

 

[A|ex]

i want the combo boxes to change depending on what you select above in whatever combo box. The whole idea of the cascading combo boxes was to filter out unwanted things for EACH record, not for all the records. I was suprised when i found out it never updated everytime u changed the parent cascading box

 

[WayneRyan]

Alex,

In the AfterUpdate event for each Parent combo, you have to do a:

Me.ChildCombo.Requery

Wayne

 

[A|ex]

Finance House
Product Code
Term

They are the levels atm:

Private Sub cboProductCode_AfterUpdate()
If IsNull(Me.cboProductCode) Then
Me.cboTerm = Null
Me.cboTerm.Enabled = False
Me.cboTerm.Locked = True
Else
Me.cboTerm.Enabled = True
Me.cboTerm.Locked = False
Me.cboTerm.Requery
End If
End Sub

Yes i do have a requery

 

[WayneRyan]

Alex,

Can you post a sample db?

Wayne

 

[A|ex]

Sorry i cant post a sample what does AFTER update mean?