if equal open form otherwise update with message

F

fishqqq

I have a continuous form with a unbound filed in the form footer
[Text37] that sums up a total from each of the records [SRef $ Share].
the header of the form has a bound field [Total Chg] with a value in
it.

the concept is when the form opens there is a total charge stated in
the hearder [Total Chg] and as the user adds records to the form they
will enter a share of the total charge that belongs to that record in
field [SRef $Share]. The form will continue to add these [SRef $
Share] values and update the unbound field in the footer [Text37]

Once the user has finished they will click [command64] which wll do
other functions.

What i would like to do is have [Text65] updated with the following
message "Please re-update all the charges" if [Text37] does not equal
[Total Chg] when the user hits the [command64] button. If [Text37]
does equal [Total Chg] then i would like [command64] to open
[fAPSPLIT] and leave [Text65] blank

Can someone help me figure this out?
thank you
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top