I have a listbox dtc which is populated from a recordset.
I want the user to select a value, the value to appear on a table together with some textboxes to be filled in, and then written to the database.
Two problems:
if I do listbox.getvalue it brings back the entire contents of the listbox all encrypted, instead of just the text that was selected. (I tried doing (recordset.fields.value("name"
) with the recordset being the one that was writing to, not the one being populated from, but, which brings us to problem 2
how do i multiple select? I tried holding down ctrl but it didn't work. What do I have to put in the code?
I would appreciate any help greatly, especially with problem 1 because I have this on many pages.
I want the user to select a value, the value to appear on a table together with some textboxes to be filled in, and then written to the database.
Two problems:
if I do listbox.getvalue it brings back the entire contents of the listbox all encrypted, instead of just the text that was selected. (I tried doing (recordset.fields.value("name"
) with the recordset being the one that was writing to, not the one being populated from, but, which brings us to problem 2how do i multiple select? I tried holding down ctrl but it didn't work. What do I have to put in the code?
I would appreciate any help greatly, especially with problem 1 because I have this on many pages.