delete from combo box

[peljo]

Why deletion from a combo box is not working ? I have a control in my form called productid. In the onClick event of this control i have :
Dim StrSQL As String
StrSQL = "DELETE * FROM [order details1] WHERE ProductID = " & Me!productid & ";"
CurrentDb.Execute StrSQL

When i change the control from a text box into a combo box nothing happens and no deletion occurs.However when i change again from como box into a text box the deletion is OK. How can i make the onclick event work also with the combo box ?

 

[PHV]

You may try the AfterUpdate event procedure of the combo.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886