Hi,

At October 14, 2004, 07:29, bamber12001 wrote:

>
> It does exactly the same thing - this was the way I originally had
> it (and I've changed it back, as I thought the same as you did). The
> error message looks like it has nothing to do with the actual
> problem, which isn't much help!

Here's the definition of OldValues:

Property OldValues[constColumnName:string] : variant;

So, you need to access the value as follows:
VarToStr(qryBudgetItems.Fields.OldValues['DESCRIPTION'])

VarToStr is to convert a variant to a string.

Because, qryBudgetItems.Fields.OldValues['DESCRIPTION'].AsString
isn't a valid syntax for a variant.

So, essentially the variant error that you were getting was valid.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)