Could anyone please help.

I have a form with a combo box and a list box. The list box is populated from a memo field in a table. The contents of the list box depends on the value of the combo, the code for this is in the InteractiveChange event of the combo (see below)

This works in most cases, BUT if the combo is clicked and the drop down list is on display and the mouse is moved over another value in the dropdown list (but nothing is actually selected ie a new value is just highlighted in the dropdown list) and then the mouse is clicked away from the combo on the listbox, the listbox is populated with contents of the memo field of the record originally on.

I know this sounds confusing but i am having difficulty explaining the problem.

The combo's RowSouce = Table1.name - and the RowSourceType = 6-Fields

The code in the interactivechange of the combo is:

with thisform
.Listcox.clear
for lnCount = 1 to memlines(Table1.memofield)
lcString = mline(alltrim(Table.memofield),lnCount)
if seek(lcString,'inanothertable','index')
.listbox.additem(inanothertable_name)
endif
endfor
.Listbox.requery
endwith

If anyone understands what i am trying to say please, can you help me.

Thanks

Nicky