Solved

Datagrids updates when I don't want it too.

Posted on 2002-04-15
5
159 Views
Last Modified: 2010-05-02
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.

0
Comment
Question by:clangl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:Ber
ID: 6943194
Could it be something as simple as changing

dtgErr.ReBind
to
dtgErr.Refresh

...?
Ber...

0
 

Author Comment

by:clangl
ID: 6943205
unfortunately.... I tried that...
0
 
LVL 2

Accepted Solution

by:
Ber earned 100 total points
ID: 6943215
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
 
LVL 52

Expert Comment

by:Ryan Chong
ID: 6943786
Refresh the DataSource of DataGrid, example:

Adodc1.Refresh ?
0
 

Author Comment

by:clangl
ID: 6946417
I've tried that too.  If I go into debug mode it does not do it.... I am at a loss
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question