Iterate through Grid Rows using VBA Code

(0) Share

Report

Posted on by Community Member

Hi there,

I have a 3rd party form that has a grid on it. It was written in Dexterity. I have been tasked with looping through the grid rows when the save button is clicked (needs to occur prior to the save) and identifying one of the columns. The problem i am facing is that there does not seem to be any easy way to loop through the rows in the grid and identify the fields.

Any ideas on how to do this? I need to do it using the VBA Editor in GP, this cannot be part of our core code base.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

You are right in that there is no easy or reliable way to do this. If it is a dexterity grid then the data is committed to the tables directly and an alternative that you can consider is to just directly read the tables. You may have to find out how to filter the table to get only the records that are currently on the grid. Usually the key(s) can be found on the parent form.

Was this reply helpful? Yes No