Hi,

I need to add an extra field to a recordset for display purposes in a grid control. I want to grab the rs from the table spin through and populate this extra field with custom data for the display. The custom data is just discarded when it's done.

I tried closing the rs, adding a field to the rs with ors.fields.append, but when I called .open on rs the new field disappeared.

I also tried creating the rs via SQL with "Select '' as DisplayName, * from MyTable", which gives me the rs but when I do rs!DisplayName = "SomeText" I get the error: Multiple step operation generated errors. Check each status value.

Anybody know how to do this?

TIA