>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?
Can this help you:
http://support.microsoft.com/support/kb/articles/Q223/7/71.ASP
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com