I can never figure out how General Joseph Stilwell (the father not the
son) could have been an American.
What has this got to do with this question? Well, in your mind
probably nothing. But in my mind, everything, and my mind is the only
mind I have available right now.
If I were doing this I guess I would take a clue from the "Now()"
thingme and create a public function in a standard module called
CriteriaBoxValue() that returned strWhere and set the value of the
SearchCriteriaBox Source to CriteriaBoxValue().
But who knows if that provides what's wanted. Only a direct test will
tell for sure.
On May 12, 10:17=A0pm, i...@[EMAIL PROTECTED]
(Analysis&Solutions) wrote:
> Hi:
>
> I'm using the following Visual Basic code to open a re****t and set the
> value of an unbound text box in its page header. =A0It works... but only
o=
n
> pages other than the first one.
>
> =A0 =A0DoCmd.OpenRe****t strRe****tName, acViewPreview, , strWhere
> =A0 =A0Re****ts(strRe****tName)("SearchCriteriaBox").Value =3D strWhere
>
> How can I get it to work on the first page too, please? =A0There are
other=
,
> regular text boxes in the page header that contain regular
> Control Sources in them, like =3DNow(), that are working fine. =A0The
> re****t's Page Header setting is "All Pages," as it should be.
>
> Thanks,
>
> --Dan
> --
> =A0T H E =A0 A N A L Y S I S =A0 A N D =A0 S O L U T I O N S =A0 C O M P
A=
N Y
> =A0 =A0 =A0 =A0 =A0 =A0 data intensive web and database programming
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0http://www.AnalysisAndSolutions.com/
> =A04015 7th Ave #4, Brooklyn NY 11232 =A0v: 718-854-0335 f: 718-854-0409
|
