News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Iterate through Grid R...

Microsoft Dynamics GP (Archived)

Iterate through Grid Rows using VBA Code

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Iterate through Grid Rows using VBA Code

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans