Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Unanswered: delete from combo box

    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 ?

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    If I had to guess, the bound column of the combo is not the value expected by the SQL. What is the row source of the combo, and what is the bound column?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts