I have a frm which comes up with a grid showing ALL orders with ORDER SET TO Invce number. On the same form, I have provided the user with a txtBox for typing in an Invoice number to enable jumping directly to that invoice number. In this system, there will be several records with the same invoice number but different line items in each record.
I am wanting to be able to highlight all of the records in the grid that match the invoice number the user has typed into the Search txtBox. Is there a way to do this? Previously, I have highlighted a single record in a grid with the code which follows...
ThisForm.Grid1.SetAll("DynamicBackColor", ;
"IIF(RECNO()=mSelectedRecord, RGB(255,0,0), RGB(255,255,255))", "Column")
I know I could SET a FILTER and accomplish my purpose, but for this form, I would rather highlight as explained above. Any help is appreciated. TIA, Chuck.
Chuck Henry