Validating Text on an Entry Field

[Isis]

I am allowing a user to edit one of the fields shown on the list,
but in a bound field underneath it - this works fine - however I want to
validate his entry based on the values in some of the other fields in the
currently highlighted record - some of these are calculated. I want to do
something like;

FieldBeingEdited Validation Text = '<= (calculated)TotalSales -
(noncalculated)Returns

I hope that makes some sense !

Basicall the field being edited cannot contain an amount greater than a
calculated field in the List minus a non calculated filed in the List.

Any more help much appreciated.

Thanks

 

[Jeff Boyce]

Isis

One approach might be to (re-)do the calculation in your expression.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Isis]

Jeff, thanks for the reply.

Are you saying I need to use a different expression ? If so, any clue as to
what that might be ? Or are you saying I need to cycle the user back to the
field just entered ? In which vase, yes, I understand that - it is the
expression that is causing the problem.

Any further help appreciated.

Thanks

 

[Jeff Boyce]

No, I was suggesting that if you have an expression that refers to another
expression, maybe you could try embedding the actual (second) expression
inside the first, rather than simply referring to the name of it.

Regards

Jeff Boyce
Microsoft Office/Access MVP