General information
Title:
Combo's and listboxes
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only