Text Box Not Populating

[TheSearcher]

I have a list box called lst_Goals. On the double-click event it should populate txt_Goal and txt_Comments with values. Here is the code:

txt_Goal = lst_Goals.Column(0)
txt_Comments = lst_Goals.Column(1)

txt_Goal poplates as it should.
txt_Comments remains blank.
I put a msgbox in the double-click event that looks like this:

msgbox lst_Goals.column(1)

It displays the value I expect to be in txt_Comments.
I then changed the code on the double-click event to this:

Me.txt_Comments = "Test"

txt_Comments still remains blank.
txt_Comments is enabled and not locked.
Has anyone run across anything like this before? I even deleted txt_Comments and recreated it but the same issue remains.
Any help will be greatly appreciated. I'm pulling my hair out and I'm already bald!

 

[theDBguy]

Can you post a sample db to demonstrate the problem?

 

[TheSearcher]

See attached.

Double-click frm_Login

Login: test
PWord: testing
Choose "Speech" from Therapy drop down
Click "Unfinished Notes"
Click "Client"
Choose Note from drop down box
Click "Goals"
Choose "Articulation" from the Category drop down box
Double-click "Compensatory Strategies - Intelligibility"

Only txt_Goal is populated
txt_Comments is not

 

[TheSearcher]

Found the problem. This was my code behind the double-click event. I wiped out the value at the end. Not a good idea.

lst_Goals_DblClick(Cancel As Integer)
txt_Goal = lst_Goals.Column(0)
txt_Comments = lst_Goals.Column(1)
cmb_Frequency = ""
cmb_Intensity = ""
txt_Comments = ""
Globals.glb_UpdateFlag = False