Sign Up Now! Log In
sgray128 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