In <8025b659-fbc6-472f-b89e-a148efee037b@[EMAIL PROTECTED]
> lyle
fairfield <lyle.fairfield@[EMAIL PROTECTED]
> writes:
>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?
You'll have to clarify. :)
>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...
That's kind of what I did. I created a hidden field on the form where
the criteria are entered and re****t opened. Then I have the text box on
the re****t call a function that, in essence, does this (naming changed
for brevity):
If SysCmd(acSysCmdGetObjectState, acForm, "frmName") <> 0 Then
getCriteria = "Criteria: " & Forms("frmName")("aName").Value
Else
getCriteria = "Criteria: none"
End If
Perhaps not the best, most elegant, way, but it works.
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
|
