Oldvalue option not given on field 1

[jgarry]

Hi, thanks in advance.

Im using oldvalue to check to see if changes have been made to a field. my problem is...

I have a fields from a table that show up but do not have an oldvalue options to them. see below:

Private Sub txt_PlanTotalCost_BeforeUpdate(Cancel As Integer)

WAU txtTableName, Me.BenKey, "txt_PlanTotalCost", Me.PlanTotalCost.Value, Me.PlanCostType.Value
End Sub


under me.planCostType.Value is the only option for Even if I create a new table. If I change it to me.plancostType.oldvalue I then get an error: Method or data member not found.

Access 97
thanks

Jim

 

[PHV]

OldValue is a property of a Control, not of a Field.
Have you tried Me!txt_PlanTotalCost.OldValue ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jgarry]

Hey PHV, that works. thanks!
to answer your question, no I did not try it that way. Lots to learn yet. I had it in my mind that the oldvalue was a part of the table/field and not the control. thank you so much for your assitance.

Yes a star for your help.

Jim