Requery Combo of Current Record in Datasheet View

[Guest]

I am new to programming and VBA.

I have a datasheet form where the user enters ticket info...ticketdate,
ticket#, etc.

cboProduct filters data based on the value in 2 other combo boxes.

What's the best way to get cboProduct to update after the other two combos
are changed. I tried this code:

Private Sub Product_Enter()
Me.ActiveControl.Requery
End Sub

But alas, it updates cboProduct for every record in the form.

 

[John Webb via AccessMonster.com]

I believe you would need to put the following code in the 'after update'
event of the two combobox controls that cboProducts is dependant upon:

me.cboProducts.ReQuery

Hopefully that helps

John Webb