>>*clmAddDate.header1.click >>LOCAL lnRec, lsOrder, lnColor >>STORE "" to lsOrder, lnColor >>lnRec = RECNO() >> >>* tag is the field name >>lsOrder=ThisForm.mGetTag(This.Tag) >>lnColor = This.ForeColor >>* get current text color >>IF lnColor = RGB(128,0,128) && purple color >> lnColor = RGB(0,0,0) && black color >> SET ORDER TO >>ELSE >> WITH This.Parent.Parent >> IF TAGNO(lsOrder)>0 && This index already exists (assume simple indexes tagname=fieldname) >> SET ORDER TO (lsOrder) >> ENDIF && TAGNO( >> lnColor = RGB(128,0,128) && purple color >> .clmUserId.header1.ForeColor = RGB(0,0,0) >> .clmEmpId.header1.ForeColor = RGB(0,0,0) >> .clmFullName.header1.ForeColor = RGB(0,0,0) >> .clmOrg.header1.ForeColor = RGB(0,0,0) >> .clmClasses.header1.ForeColor = RGB(0,0,0) >> .clmCity.header1.ForeColor = RGB(0,0,0) >> .clmBldg.header1.ForeColor = RGB(0,0,0) >> .clmDates.header1.ForeColor = RGB(0,0,0) >> ENDWITH >>ENDIF && lnColor = RGB( >>This.ForeColor = lnColor >>This.Parent.Parent.Refresh() >> >>GOTO lnRec >>This.Parent.Parent.clmAddDate.SetFocus >>>>