multiline input table apocalypse

[dulux1309]

Hi all - really struggling here.

I have a multiline input box for collecting a list that is to be used to populate a combobox. I am trying to read the contents of the input box into a table and from there into a database, with each entry in the input box going into a different field. However I do it, I am only getting the input box return as a string, with boxes where the newline character sits. Do I need some complicated loop to look for the newline character and break the input apart like this? I could do it using 20 input boxes, but I would like something more elegant and less time consuming...

[dulux1309]

No worries - I have a workaround -

I have a combobox with the names of the different comboboxes that are editable. I have 20 input boxes - 1 for each of the elements in the tables for each combobox. The user chooses which combobox he is modifying, and then saves the changes to the appropriate table. The boxes are then cleared and a different combobox can be selected for amendment.


This way, the user can easily change an entry in a combobox without me resorting to complicated scripting, and I can get on with finding the next obstacle... :-D