I have the following VB code on the onChange event of an unbound combobox:
Private Sub Std_Results_Change()
On Error GoTo Err_Std_Results_Change
Me.CCDetails = Me.CCDetails & Me.Std_Results.Value
It works OK but isn't doing excactly what I would like. At the moment the text enters the field (Me.CCDetails) in a long line, how can I get each additional 'OnChange' to for a new line?
Also how can I free up the memory on the combobox? As it is the combobox stores the choises in memory so if you make a misstake and choose wrong item in combobox, delete it and rechoose it will remember the first and stick them both in CCDetails. I've tried a requery as you can see in the code but has not worked. Is this in the wrong place?
The second problem still remains though. The msgbox was a nice I dear but even if I close down that record and then open the next one it still remembers the info and when you enter your first combobox option you get that plus all the options you chose in the first record?