I found my answer to the Dcount issue.
1. Needed the [ ] around the table and field names
2.Tried to use the equation to combine pieces of variable name
-Instead predefined the variables and then just used the variables in the equation
3.Realized did not need to put " " around variable name
Code:
'Before - dcount field and table names used a more complex name set (had " " around variable name')
- missing [ ] around field and table name/variable
TB_Cn = TB_C.Name 'table name ex: dc1_current
TBF_B = TB_B.Fields(l).Name 'Field name ex: Component
dc = DCount(" & TBF_B & ", " & TB_Cn & ") ' attempt to use variables above in equation and add " manually
'After - I predefined the dcount variables for field and table and added the [] in the predefined variables
' - Realized I did not need to add the " " around variable name
TB_Cn = "[" & TB_C.Name & "]" 'table name ex: [dc1_current]
TBF_B = "[" & TB_B.Fields(l).Name & "]" 'Field name ex: [Component]
dc = DCount(TBF_B, TB_Cn)
then used the result of empty or a number to either add to error message or just go to next field
Code:
If IsEmpty(dc) = True Then
Bf_message = Bf_message & vbCrLf & TBF_B
End If
'then moved to next field in loop and displayed bfmessage after loop finished
Thank you for all the help