Since you haven't used code tags, I'm not sure if you have three separate lines or six separate lines. If three, then what you have should work. If six, then you
End If after each If statement.
Have you tested this? At first glance, nothings looks wrong, although if
Me.PullForce and
Me.Nuggets are number fields, then you should be testing for
IsNull() instead of empty strings (which is what "" is). Where do you have this code? Do you get any error messages when it runs, or do you just not get the results that you expect?
Also, please read
Before Posting (VBA or SQL) Code before posting any more code. It is really important to follow these rules as it helps us read your code and see problems.