@Steve, that's it. Example right out of my procedure (ignore that I break normalization rules):
Code:If Not IsNull(![207.LabNum]) Then !frac1 = .tbxFrac1 !frac2 = .tbxFrac2 End If
@Steve, that's it. Example right out of my procedure (ignore that I break normalization rules):
Code:If Not IsNull(![207.LabNum]) Then !frac1 = .tbxFrac1 !frac2 = .tbxFrac2 End If
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
@June, Looking at the example code, I see " !frac1". are you using something like
Code:With Me.recordsource If Not IsNull(![207.LabNum]) Then !frac1 = .tbxFrac1 !frac2 = .tbxFrac2 End If End With
Not quite, just:
With Me
...
End With
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.