>>Thanks Eric! You ROCK!!
>>
>>Now I need to look up sorting this grid on the fly. Any suggestions?
>
>Are you using ADO?
>
>Yes: You can use the Sort method of the recordset.
>No: You have to requery the database with the new "Order by" clause.
I used ADO to create a recordset and filled the grid in from the recordset. The sort function seems to work OK. I am just trying to allow a toggle on the header row.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams