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. It works... but only on
pages other than the first one.
DoCmd.OpenRe****t strRe****tName, acViewPreview, , strWhere
Re****ts(strRe****tName)("SearchCriteriaBox").Value = strWhere
How can I get it to work on the first page too, please? There are other,
regular text boxes in the page header that contain regular
Control Sources in them, like =Now(), that are working fine. The
re****t's Page Header setting is "All Pages," as it should be.
Thanks,
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409


|