VB6 ADO refresh button click - Help please
The app I'm making displays 3 qrys from a database in labels. Since I'm a newb with VB Iíve used 3 ADO controls to connect to my database to pull the 3 different qrys and display the data in my labels. The problem I'm having is with refreshing the displayed data. I'm using a label as my refresh button so that I can have a graphic as the button. When my app is running and I click the refresh button only 1 of the ADO controls are refreshed.
Here is the code for the label/button:
Private Sub lblRefresh_Click()
On Error GoTo UpdateErr
Only Adodc3 is refreshed when the button is clicked. Can anyone tell me if there is a problem with what I'm doing here?
Also, the qrys the ADO controls are using are from related tables in my Access database. Like qry1 and qry2 divided by each other make qry3. Qry1, qry2 and qry3 are all displayed on the form. Could it be because the qrys use each other to get the result?
Any help would be greatly appreciated.
I think you should install latest service pack.
I've already updated to SP6.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center