Question:
I am using a subroutine which involves 2 list boxes in a pick box configuration. I take the literal boxname [Form.Control] and load it to a variable- BoxName. I then pass this to a module sub which processes the data. When I try to get the number of items in the output list, by combining BoxName with the ListCount statement then it doesn’t yield the list count.
The code goes something like this:
ItemCount=BoxName+".Listcount
Why isn’t this working?
Answer:
Try this:
Dim BoxName as ControlSet BoxName = Form.ControlYou can then use BoxName.ListCount and that will work fine. You really cannot get the name of a control, but you can set it to another generic control type, like “Control”. You could also use “ListBox” as the type name.