ACCESS FEED: RE: [MS_AccessPros] Why does Access not recognize subreport with the "rpt" prefix

Kamis, 27 Oktober 2011

RE: [MS_AccessPros] Why does Access not recognize subreport with the "rpt" prefix

Thank you Bill, that is exactly what it is. At least I'm not flying blind
now J.

Have a great evening and an even greater day tomorrow.

Sincerely,

David

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Thursday, October 27, 2011 4:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Why does Access not recognize subreport with
the "rpt" prefix

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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
djsdaddy531
Sent: Thursday, October 27, 2011 1:13 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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]

[Non-text portions of this message have been removed]