I know what I am doing well.
Then do not sell yourself as a begginner in need of help. The responses we would give to a seasoned programmer are very different from a beginner.
Did you write the code in basFillFieldsFromListbox? If so what problems are you having? I do not understand since it seems most of the code is there to do what you want.
Can you tell us which form and which textbox is to be filled from the listbox?
The problem I see and not included is assume I have a textbox to be filled from choices in a listbox
If the values in the textbox are
Dog
Cat
Mouse
Which is really a string with VBCRLF between the values
When you click again for the listbox how are you going to exclude from the selections Dog, Cat, and Mouse so that you do not click them again. It can be done by not trivially.
I am sure you have not looked at the file. Please, if you have time, take a look at the file
We have all looked at the file, and thus are questions on what you are doing. When we see this.
When we see this a text field holding multiple values, we are going to question what you are doing.
color |
---|
Bloody
Brownish
Darkbrown
Greenish |
Brownish |
stool_tbl
If I absolutely had to do this, it would work this way.
1. Click on the text box and open generic List form. Pass in the rowsource based on the field.
2. If choices already exist in the text box Need to parse those
("Bloody", "Brownish"....)
3. Create rowsource "Select FixedResults from FixedResults_Tbl where FixedName = "(Urine) Color" and FixedName not in ("Bloody", "Brownish"...)
4. Now in the multi select listbox Highlight the choices "Bloody", "Brownish"
5. User selects or unselects and rebuilds the list.
6. Pass list to form.