Eval function and Date

  • Thread starter Thread starter Indu Aronson
  • Start date Start date
I

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
Click to expand...
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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Indu Aronson said:
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
Click to expand...
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
Click to expand...
 
Back
Top