David
Check the name of the sub report *control* on the main report. This might not be
the same as the actual sub report. The control name is the one you have to use.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of djsdaddy531
Sent: Thursday, October 27, 2011 1:13 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Why does Access not recognize subreport with the "rpt"
prefix
When I open a report, there is a routine that checks for a certain condition. If
the condition is met, then the Visible Property of one of two of my subreports
will be set to "True;" however, if the condition is not met, the Visible
Property will be set to "False." I kept getting an error that Access could not
find the field name "[a straight vertical line]". It was a straight verticle
line in the error message between two quotes. Here is the code:
If Me.OpenArgs = "RepairOrder" Then
[rptParts-RepairOrder subreport].Visible = True
Else
[rptParts-RepairOrder subreport].Visible = False
End If
The field name is spelled correctly, but when I went to the expression builder
to see if the form was there, and discovered it was spelled with the "frm"
prefix. Notwithstanding that the report has an "rpt" prefix, I changed the code
(above) to the "frm" prefix and the code works. I do not want to have any false
sense of security here, so I'd like to know if anyone can explain this to me.
Thanks in advance.
r/David
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar