Looking for help. Please try the following.
Create a blank form. Create three text boxes called txtTotal, txtAmount1, txtAmount2. Create a command button. In the click event put the following
Dim amount1 As Double
Dim amount2 As Double
Dim total As Double
amount1 = cdbl(txt1Amount)
amount2 = cdbl(txt2Amount)
total = cdbl(txtTotal)
If amount1 + amount2 <> total Then
Debug.Print x + y
MsgBox “Access cannot add”
Run the form. Put a number into txtAmount1 and txtAmount2. Put the total of these two numbers in txtAmount. Click the button.
Let me know if it displays the message. It shouldnt display the message but for some reason I cant figure out why it does. 25 years of combined programming experience cannot come up with an answer. Any help appreciated.
BTW it does the same thing in Access 97 and 2000.