>>>*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 >>>>>>