I am look at the array after I do following (I move my code from interactive change in combobox to just a field called retire_type in lostfocus procedure)

*****************************
select payroll_tbl.retireperc from payroll_tbl ;
where payroll_tbl.retire_type == 'G' into array a__gen33
If type('a__gen33') # 'U' and type('a__gen33') # 'L'
b1 = alen(a__gen33)
if b1 = 1
.pf1.p5.txtRetireperc.value = (a__gen33(1,1)) &&latest retirement percent
.pf1.p5.txtRetireperc.refresh()
.recalc_benefit
else
.pf1.p5.txtRetireperc.value = (a__gen33(b1,1)) &&latest retirement percent
.pf1.p5.txtRetireperc.refresh()
.recalc_benefit
endif
else
x=y &&latest retirement percent not found
endif
release a__gen33
***************************

in my retire_type.lostfocus. I am stepping through using the debugger and it seems like the array doesn't contain anything. There should be some information there because I did an

**********************
Insert Into Payroll_tbl (retire_type) value (something)
**********************

just before gotfocus to this field. If I exit this form and comeback in, it works fine.

thanks
Nick Patel