equals the same otherwise give an error message

F

fishqqq

I have a form with two continuous subforms in it that lists the AP &
AR entries for a transaction.
Each of these entries has a BUY/SELL currency as well as a file
currency
(a user can enter a buy rate of $10.00 CDN but the file currency may
be USD.)

The issue is all the AP & AR entries (for a particular transaction)
need to have the file currency of either USD or CDN. Currently the
system will allow the user to enter either USD or CDN for each record
but once the user chooses USD or CDN then all the other AP &AR entries
for the transaction need to have the same file currency.

So what I'd like to do is have the close button review all the file
currencies to ensure they are all the same (either USD or CDN) and if
not show an error message instead of closing the form.


the AR field is:
Forms![Profit Tracking 2]![Profit Tracking (Receivables)].Form![Total
Line Amount Curr]

the AP field is:
Forms![Profit Tracking 2]![Profit Tracking (Costs)].Form![File
Currency]

Can someone please suggest how i can get these two fields compared
then either have the form close or an error message stated?

thanks
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

Similar Threads

sum the currency sort 2
Using the data from different record 1
filtering then summing a field 2
Embed the same Excel multiple times 0
Return value from column 2
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Active Content in this file is blocked issue 1
Selecting items from list and attaching ratios to selection 0

Top