How to populate a combobox on the form? I am reading file name and path from a profile to display in the drop down list. File is csv format. I don’t get any error messages but drop down list is blank. Do you know any work around for this issue? Thank you,
Subject: How to populate combobox from a csv file
Impossible to judge without knowing your code.
Do you really want the list values to be pulled from the csv file each and every time, a form is loaded? If yes, then why?
Subject: RE: How to populate combobox from a csv file
The list residing on the a different server. Each time a new form created I need to display this information to allow the end users to select an option. Since the list will be updated on a routinely bases I need to provided access to the updated list without any interaction. Is it possible?
Subject: RE: How to populate combobox from a csv file
Yes, it’s possible, but not with only a formula. You would have to use other code – LotusScript, for instance – to store the list where the keyword formula can find it. A personal profile document might be a good place to store the information temporarily. It’s not something you can do with a few lines of code.