Thanks, I solved the issue in code:
Code:
Private Function fnPeriod(Per As Variant) As Variant
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
' Need the function sensitive to the case where there's no record, lest new
' addition fields appear as "#Error".
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
If Not IsNull(Per) Then
fnPeriod = DLookup("PerName", "tblPeriods", "[Period] = " & Per)
End If
End Function
Thanks for the suggestion,
Bill