Dialog options

E.Heizyk

Forums

Hi I am trying to put together a dialog window to accomplish the following:
Dropdown that allows the user to select any field from the active databse.
Each unique value from that field show up  allowing the user to check off values to be handeled differently later in the program.
 
Is this possible, if so, do you have any resources that could help me accomplish the task? I already have the dialog box built and working for the rest of the program, I am trying to add this on.
Thanks!

E.Heizyk Thu, 03/14/2019 - 18:12

I found out that there is no way to select multiple items from a Drop List Box, and found your example of using listboxes to select files / fields and I am working on using that to solve my problem. 
I attached the script I am working on. 
DropListBox1 is accurately pulling each field from the databse. Then I need to select PushButton2 where a second window opens, (dlgDetermineEECodes) where each unique item from the field selected in DropListBox1 is populated into ListBox1.
When I run the script, I am getting the error 'Subscript out of Range' on line 324 once I click PushButton2 on my NewDialog window.

Brian Element Fri, 03/15/2019 - 13:48

The problem I see is that you are calling the getFields() function for the drop-down and also to populate the listBox but the listBox should be populated based on the contents of the field in the drop-down if I am understanding your script.  Also the listBox is looking for an array called Fields (maybe should rename this) to populate the listbox where as this array never gets populated, that is why you are getting the error.