web

You’re offline. This is a read only version of the page.

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

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 Img

All responses (1)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

#1

Anthony Beatty 2

#3

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans