Datagrids updates when I don't want it too.

I have a datagrid that I use just as a reference for the user to double click on the record they want to use

Private Sub dtgErr_DblClick()
Dim frmDet As New frmErrDetail
frmDet.TransId = dtgErr.Columns(1)
frmDet.BatchId = dtgErr.Columns(0)
frmDet.Fil = cboErrs.Text
dtgErr.col = 0
frmDet.Show vbModal
Unload frmDet
Set frmDet = Nothing

adoCon.Refresh
dtgErr.ReBind
Call CheckLastRec

End Sub

The call and the frmDet do not do anything to the datagrid
when I go back to the datagrid it update the column 0 with whatever I have double clicked on.  
All I want to do is refresh the datagrid.

clanglAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
BerConnect With a Mentor Commented:
Have you tried requerying the database with something similar to this

Select * from tablename

and then rebinding or refreshing the datagrid. Unfortunately I cannot write any code at the moment as I had a major system failure in the last couple of days and have lost Office(so no database software) and am getting some strange results from VB but give it a try and see
...
0
 
BerCommented:
Could it be something as simple as changing

dtgErr.ReBind
to
dtgErr.Refresh

...?
Ber...

0
 
clanglAuthor Commented:
unfortunately.... I tried that...
0
 
Ryan ChongCommented:
Refresh the DataSource of DataGrid, example:

Adodc1.Refresh ?
0
 
clanglAuthor Commented:
I've tried that too.  If I go into debug mode it does not do it.... I am at a loss
0
All Courses

From novice to tech pro — start learning today.