two value in forms

[miziri]

Hi,
friend I have in this database inside parents forms with two fields call value1 and value2
when I enter value into child forms inside field call value2 it must all they time smaller then value1
in case the value inside value2 is bigger I need Massage box appear The value is big and not permit to change value.


see attached file

thanks

[RuralGuy]

Just put validation code in the BeforeUpdate event of the Value2 control.

[miziri]

Hi,
friend I have edit that filed name into balance and sum,balance its in parent form,sum in child form


thx

[miziri]

Hi,
see edit database

thx

[genesis]

let me see.wait

I see, that you have already followed the advice of RG. do you still have problem?