>Hi Alex,
>
>I was trying to do something similar in VB this weekend. I think the problem is you can't just add a field to a connected recordset. I tried to just use "junk" as ExtraColumn, but it would always error when I tried to replace any data in it. See :
>Forum: Visual Basic and VB.Net Category: Database DAO/RDO/ODBC/ADO Title: Re: How to add a temporary field to an ADO rs Thread #517413 Message #517538 for a possible solution. It uses a shaped recordset to get around the problem.
>
>hthThat KB refers to appending new records. In my case it was a readonly record that I wanted to do the ADO equivalemnte of replace. (recordset.record.value = something)
Thx.
BTW, let me know when you are in Dade with soime time, preferably later in the day. I just moved to a new place in Bay Harbor (basically N. Miami Beach) so I'm closer to you.