Hello,
I want to make a form with a dropdown menu in access that lets you choose the name of a customer and execute a query by clicking a button.
So I made my list, my button, the button's click event I put this, here is part of the code.
Private Sub Commande5_Click()
Sun stdcnm As String
stdcnm = "Query tracks customer"
DoCmd.OpenQuery stdcnm, acNormal, acEdit
End Sub
And I modified the test case of my request at the Customer name and I added this to my code.
Modifiable2 is the name of my list. So normally my application should run normally when I click on the button and then nothing. In testing it works manually so there's really a problem with the query criteria. I tried coding in the application directly in VBA, but same result (well worse the application does not work when I copied the SQL). In short, a very strange problem that I recall why I quickly stopped using access.[forms]![Form-Client Tracks]![Modifiable2]
Bookmarks