choose date in report

Hi! I am new with Access. I made a little database and I made report too.
Report use Date from the Table. I like that when I open a Report that I
choose a date: for example between 4/22/2005 to 11/15/2005. I made a form
where did I put a beginning date and ending date. And now I don't know how to
connect this form to the Report. O.K. when I open a Report, first open a new
form and it ask me about date but than I don't know how to save the date.
Please help me. Thank you.

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"date" wrote in message
news
Hi! I am new with Access. I made a little database and I made report too.
Report use Date from the Table. I like that when I open a Report that I
choose a date: for example between 4/22/2005 to 11/15/2005. I made a form
where did I put a beginning date and ending date. And now I don't know how
to
connect this form to the Report. O.K. when I open a Report, first open a
new
form and it ask me about date but than I don't know how to save the date.
Please help me. Thank you.

Thank you for you answer but i have a problem still.
I open the report in Design View but i don't know where or how should i set
the Control Source.
I made report from table datas.

Thanks a lot.

"Allen Browne" wrote:

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"date" wrote in message
news
Hi! I am new with Access. I made a little database and I made report too.
Report use Date from the Table. I like that when I open a Report that I
choose a date: for example between 4/22/2005 to 11/15/2005. I made a form
where did I put a beginning date and ending date. And now I don't know how
to
connect this form to the Report. O.K. when I open a Report, first open a
new
form and it ask me about date but than I don't know how to save the date.
Please help me. Thank you.

With the report open in deign view, right-click the text box whose Control
Source you want to set. Choose Properties.

In the Properites box, on the Data tab, set the Control Source.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"date" wrote in message
...
Thank you for you answer but i have a problem still.
I open the report in Design View but i don't know where or how should i
set
the Control Source.
I made report from table datas.

Thanks a lot.

"Allen Browne" wrote:

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

"date" wrote in message
news
Hi! I am new with Access. I made a little database and I made report
too.
Report use Date from the Table. I like that when I open a Report that I
choose a date: for example between 4/22/2005 to 11/15/2005. I made a
form
where did I put a beginning date and ending date. And now I don't know
how
to
connect this form to the Report. O.K. when I open a Report, first open
a
new
form and it ask me about date but than I don't know how to save the
date.
Please help me. Thank you.

Thank you again
I did but when i run i get an run-time error 438:

and this line is yellow in the debug window:

strWhere = strField & " " & Format(Me.txtStartDate, conDateFormat)

"Allen Browne" wrote:

With the report open in deign view, right-click the text box whose Control
Source you want to set. Choose Properties.

In the Properites box, on the Data tab, set the Control Source.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"date" wrote in message
...
Thank you for you answer but i have a problem still.
I open the report in Design View but i don't know where or how should i
set
the Control Source.
I made report from table datas.

Thanks a lot.

"Allen Browne" wrote:

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

"date" wrote in message
news Hi! I am new with Access. I made a little database and I made report
too.
Report use Date from the Table. I like that when I open a Report that I
choose a date: for example between 4/22/2005 to 11/15/2005. I made a
form
where did I put a beginning date and ending date. And now I don't know
how
to
connect this form to the Report. O.K. when I open a Report, first open
a
new
form and it ask me about date but than I don't know how to save the
date.
Please help me. Thank you.

It would appear that your form does not have a text box named txtStartDate.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"date" wrote in message
...
Thank you again
I did but when i run i get an run-time error 438:

and this line is yellow in the debug window:

strWhere = strField & " " & Format(Me.txtStartDate, conDateFormat)

"Allen Browne" wrote:

With the report open in deign view, right-click the text box whose
Control
Source you want to set. Choose Properties.

In the Properites box, on the Data tab, set the Control Source.


"date" wrote in message
...
Thank you for you answer but i have a problem still.
I open the report in Design View but i don't know where or how should i
set
the Control Source.
I made report from table datas.

Thanks a lot.

"Allen Browne" wrote:

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

"date" wrote in message
news Hi! I am new with Access. I made a little database and I made report
too.
Report use Date from the Table. I like that when I open a Report
that I
choose a date: for example between 4/22/2005 to 11/15/2005. I made a
form
where did I put a beginning date and ending date. And now I don't
know
how
to
connect this form to the Report. O.K. when I open a Report, first
open
a
new
form and it ask me about date but than I don't know how to save the
date.
Please help me. Thank you.