Hi,

just trying to get a messagebox to show a value from a table but kind of struggling. well infact, really struggling!

i am in a form ( notes ) and i have a listbox that shows all of the notes to date. i am trying to show a vb messagebox that will present the specific note when the listbox is double clicked. can i even do this or is it best to create custom form?

regs,

Nigel

Dim strData As String

strData = Me.lstMyListBox.Column(1, Me.lstMyListBox.ListIndex)
MsgBox (strData)