hi all,

i need to insert two things at mycode under.
1. if not found()
=messagebox("not found")
else
....
endif
2. if i want to sum columns at the same code as
sum t1 to thisform.pageframe1.page2.tex1.value

any idea ,help

with thisform.pageframe1.page2.Grid1
    .RecordsourceType = 4 && SQL
    .Columncount = -1
      .Recordsource = 'select * from mstr'+ ;
      '   where UPPER(inname) = UPPER(TRIM(thisform.pageframe1.page1.text1.Value)) ' + ;
         'and nam1 = thisform.pageframe1.page1.text4.Value'+ ;
'   into cursor crsMyCursor'
    
ENDWITH

thisform.pageframe1.page2.Grid1.refresh

thanks
m.qasem