Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

datagrid problem

Status
Not open for further replies.

jrlbw

Programmer
Jun 27, 2002
15
US

I am using a datagrid to produce a form containing all rows in a table that satisfied a search.
I want to click on the row desired, return, and produce a form with all the data about that particular row.

I can click on all the rows from #2 on down and get the desired values....
but when i click on row#1, i get back null values...

i use the colrowchange event to select the values from the columns....
why not row number 1??????
 

Don't know....would have to see the code in the DBGrid1_RowColChange event.

I seem to remember something about a bug like this a long time ago. So, before going any further, are you using VB6 SP5? If not then download and install it first. And, because you mention "DataGrid", I assum that you are using an OLEDB DataGrid and an ADO recordset or data control. Is This correct? If so, then are you using a DataControl and binding the grid to it?

What does ?rs(0) or ?DataGrid1.Recordset(0) in the immediate window produce if you put a break point in the DBGrid1_RowColChange event?

If the problem still exists, then you'll need to post some code.... [/b][/i][/u]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top