I'll be honest im not an expert at MS access...but
how do i properly form an if/then formula for access
[Box1] - random empty box that has random number
[Box2] - contains formula to a total in a subform footer.
I suppose in excell the formula would be
this is what i want in box 3
=if([box1]<[box2], "yes", "No"
if you understand please help.
thank You
Assuming that box1 and box3 are on the main main form and this code is executed from the main form using a button click. box2 is on the subform.
-
Private Sub Yourbutton_Click()
-
If Me.[box1].Value < Me.YourSubformControl.Form.[box2] Then
-
Me.[box3].Value = "Yes"
-
Else
-
Me.[box3].Value = "No"
-
End If
-
End Sub