>How would I go about looking through each column of a grid to find a certain value. What I want to do is to use a loop to go through the columns but I am unsure how to code going from one column to another. Any suggestions?
>
>Thanks in advance
>Kelly
Don't loop through the grid, loop through the grid's source cursor instead.
e.g.
LParameters tuValue
Local lcCursor, ji
lcCursor=thisform.grid.RecordSource
Select (lcCursor)
For ji = 1 to FCount()
If Type(Field(ji))=Type("tuValue") and Eval(Field(ji))=tuValue
EndIf
Next
Insanity: Doing the same thing over and over and expecting different results.