Thanks Larry
I only wanted to be able to use the pop up calendar
when I opened a report, to be able to enter date requested for report
I probably mistated what I was trying to do.
The way I now have it, when I open a report, I have to enter
date I want by typing it in. Like this 11/18/05 They have to use the
slash mark between the numbers I only have this with reports & query
It is the criteria in my querry, is there any way to get the pop up there?
I thought a pop up calender would
eleminate errors. Any Ideas
Thanks for the help
Roger
"Larry Linson" wrote:
>
> "XeniaEagle" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7705-pop-up-calendar-in-report.html
> news:B4A07772-8F2B-489A-B21A-F83F1A328C37@microsoft.com...
> > Thanks Larry
> > I have put the calendar in my form, but i can't
> > get my report to use the form as a record source.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
> > What am I doing wrong?
> > It only gives me querry or table.
> > Query is where I have the between start and end dates
> > Thanks for any help
> > Roger
>
> I apologize if I left the impression that you could use a Form as
> RecordSource for a Report -- you can't, and it was not my intention to imply
> that you could.
>
> You collect those dates from the Text Boxes on the Form, and, in VBA code,
> construct the WhereCondition clause of a DoCmd.OpenReport that you use to
> open the report, or (a little more work, but more efficient) construct an
> SQL statement that you pass to the Report for use as its RecordSource.
>
> Larry Linson
>
>
>