m17347047711116
Registered User.
- Local time
- Today, 09:45
- Joined
- Feb 4, 2002
- Messages
- 68
Searched the threads and there seems to be a lot of info but my inexperience makes it difficult to understand, so forgive me if this is a common question:
I have a Form with the following fields:
[Score1], [Score2], [Score3]
I also have an unbound box on this form [Sum] that adds the scores together
=[Score1]+[Score2]+[Score3]
I have another field on this form:
[Manual Sum], this is transferred from a judges score sheet
All i want to do is put some simple code behind the form that might look like this:
IIF [Manual Sum] is < > [Sum] Then
MsgBox "The Judges Total is not correct do you wish to continue vba yes,no"
But I can't quite get it to work or find quite the same issue in the forum.
I have a Form with the following fields:
[Score1], [Score2], [Score3]
I also have an unbound box on this form [Sum] that adds the scores together
=[Score1]+[Score2]+[Score3]
I have another field on this form:
[Manual Sum], this is transferred from a judges score sheet
All i want to do is put some simple code behind the form that might look like this:
IIF [Manual Sum] is < > [Sum] Then
MsgBox "The Judges Total is not correct do you wish to continue vba yes,no"
But I can't quite get it to work or find quite the same issue in the forum.
