How do I get the box to appear when i open my report? I want it to ask for
month year so I can type in for example 10/2007.

Thanks

One approach would be to add a control on the report and set its
ControlSource to something like (untested):

=[enter a mm/yyyy]

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Chey" <(E-Mail Removed)> wrote in message
news:E335C641-0000-4E11-91DE-(E-Mail Removed)...
> How do I get the box to appear when i open my report? I want it to ask
> for
> month year so I can type in for example 10/2007.
>
> Thanks

I have a field in my report that it is suppose to query it by though. I have
done the between dates but I don't need multiple date. I just need one. I
believe I put it in the critiera before.

Thanks

"Jeff Boyce" wrote:

> One approach would be to add a control on the report and set its
> ControlSource to something like (untested):
>
> =[enter a mm/yyyy]
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Chey" <(E-Mail Removed)> wrote in message
> news:E335C641-0000-4E11-91DE-(E-Mail Removed)...
> > How do I get the box to appear when i open my report? I want it to ask
> > for
> > month year so I can type in for example 10/2007.
> >
> > Thanks
>
>
>

I got it to work.

Thanks

"Jeff Boyce" wrote:

> One approach would be to add a control on the report and set its
> ControlSource to something like (untested):
>
> =[enter a mm/yyyy]
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Chey" <(E-Mail Removed)> wrote in message
> news:E335C641-0000-4E11-91DE-(E-Mail Removed)...
> > How do I get the box to appear when i open my report? I want it to ask
> > for
> > month year so I can type in for example 10/2007.
> >
> > Thanks
>
>
>