Points: 54425

4/28/2012 12:08:37 AM

VS Tools/VBA - Populating a dropdown list

* This article, and all our great VBA documentation, Is available on the VBA/Modifier menu

This is one of the cooler pieces of code that I've come across in a while.

This technique is coded using VS Tools, but it was ported from VBA code so it'll run just fine in VBA. You'll have to edit the data access code in that case to use ADODB.

The object here is to place a dropdown list on a NATIVE Dynamics form (not one that you added using .NET) and then to populate the dropdown with data.

This piece of code uses 'Pass through SanScript' to do the deed. It's not too complicated and it works just fine, well worth studying.

If I've not explained it clearly please let me know, I'll help.
Version: GP 2010
Section: Visual Studio Tools for Dynamics GP,VBA
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables