Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 execute query and display result in text box

Author  Topic 

mike009
Starting Member

15 Posts

Posted - 2006-05-11 : 08:40:53
hi
i have problem executing query
i have form with :

1- combobox (list of customer id's)
2- searchButton (to execute query)
3- text field to show results

what should happen is, first select customer id from the combobox and click on search button, the query will be executed this query will select all orders with this customer id
here i add click event on the click button

Private Sub searchB_Click()
Dim querystring As String
querystring ="Select * From Order where Custmerid =" & customerCB.value

how can i run this query and how can i display the result in text box


thx
   

- Advertisement -