The listbox does not seem to respond... In the click event of a combo I have the following
do case
case thisform.mycombobox1.value ='Noun'
inde on noun to c:\csu-zeta\z
case thisform.mycombobox1.value ='Part#'
inde on part_nbr to c:\csu-zeta\z
case thisform.mycombobox1.value ='serial#'
inde on serial_nbr to c:\csu-zeta\z
ENDCASE
thisform.MYLISTBOX1.REQUERY
In the form's activate I have:
with thisform.mylistbox1
.rowsource="select owc,noun,pmel_id,part_nbr,serial_nbr,rek from &LD:pmel into curs zpmel"
.refresh
.columncount=5
endwith
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."