B
Bill
In the code segment below, I'm attempting to reference
text-box controls on an open report from a general
module. The name of the report is passed to the general
module "RptName as String". I've tried several configurations
of the "With" statement, but so far nothing but runtime
errors pertaining to the "un-recognized" name of the
report.
What would be the correct syntax for such a reference?
Thanks,
Bill
==========================================
With Reports![RptName]!Controls
' Case Selection below attends to lines 1 and 2
Select Case FmtID
Case 1 'HOH & Spouse (with any Children on 2nd line)
!tbLn1 = HOH & " & " & Sp & " " & LastName
If Len(Ch) > 0 Then
!tbLn2 = Ch
Else
!tbLn2 = ""
End If
..
..
..
..
end with
text-box controls on an open report from a general
module. The name of the report is passed to the general
module "RptName as String". I've tried several configurations
of the "With" statement, but so far nothing but runtime
errors pertaining to the "un-recognized" name of the
report.
What would be the correct syntax for such a reference?
Thanks,
Bill
==========================================
With Reports![RptName]!Controls
' Case Selection below attends to lines 1 and 2
Select Case FmtID
Case 1 'HOH & Spouse (with any Children on 2nd line)
!tbLn1 = HOH & " & " & Sp & " " & LastName
If Len(Ch) > 0 Then
!tbLn2 = Ch
Else
!tbLn2 = ""
End If
..
..
..
..
end with