> > SELECT 0 > USE AuditCls > APPEND BLANK > replace userid WITH gcNovellId, sdate WITH DATETIME(), numRec WITH nTltRecs,ieflag WITH "I" > USE > >**and the TXTLASTIMPORTDATE textbox Init event in myform.scx : > >LOCAL lcLastImportDate,lctestdate > >SELECT TOP 1 Sdate,userid ; > FROM AuditCls ; > GROUP BY 1 ; > ORDER BY 1 DESC WHERE IEFLAG = "I" ; > INTO CURSOR top1 > >SELECT top1 > >lcLastImportDate = sdate > >lcLastImportDate = TRANSFORM(lcLastImportDate,'@YL') +' by '+userid > >thisform.TXTLASTIMPORTDATE.Value=lcLastImportDate > >Thisform.txtLastImportDate.Refresh() > >>