clangl
asked on
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.
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.
ASKER
unfortunately.... I tried that...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Refresh the DataSource of DataGrid, example:
Adodc1.Refresh ?
Adodc1.Refresh ?
ASKER
I've tried that too. If I go into debug mode it does not do it.... I am at a loss
dtgErr.ReBind
to
dtgErr.Refresh
...?
Ber...