Eval function and Date

[Indu Aronson]

I have the following and it works without any problem
when placed in the criteria line of a date field called
Date1:

=Eval("InputBox(""Please Enter a Date: "",""Items

Closed"",Date()-3)")

However, when I add a parameter query called [Volunteer's
Name] under a field called Last, I get prompted three
times by the Evaluation prompt.

The correct records are still retrieved but it is
something of a nuisance to be prompted so many times.
Anyone have any idea as to what I might do to be prompted
once by the Parameter and once by the Eval MsgBox?

Cheers,
Indu

 

[[MVP] S. Clark]

Personally, I would build a form to prompt the user for the information, and
scrap both the inputbox and parameter.

But, for quick and dirty, I would use one method or the other, but not both.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have the following and it works without any problem
when placed in the criteria line of a date field called
Date1:

=Eval("InputBox(""Please Enter a Date: "",""Items

Closed"",Date()-3)")

However, when I add a parameter query called [Volunteer's
Name] under a field called Last, I get prompted three
times by the Evaluation prompt.

The correct records are still retrieved but it is
something of a nuisance to be prompted so many times.
Anyone have any idea as to what I might do to be prompted
once by the Parameter and once by the Eval MsgBox?

Cheers,
Indu