Input box

R

redFred

I have a batch report to run and need the user to select the date to report
for. This does not need a range, simply one date. Currently, I have in the
[BatchDate] column of the report's query the following:

[Enter batch date to run] Or Date()

This works fine, but I would rather have an standard Input box.

The report is currently opened on form [MainMenu] via a button. I am
thinking I should be able to remove the above query criteria in favor of an
input box on the report's open/load event. I don't know how to do that.

Can someone show me the way?

Thanks so much.
 
B

bhicks11 via AccessMonster.com

Create a small form with a control to input the date. In the On Lost Focus
event of that control put your code (or macro) to open the form (or report).
On opening the form (or report) I would put code to set the first forms
VISIBLE option to NO and in the form's (or report's) OnClose event Close the
first form. In the report's datasource query change the criteria to the date
control on the first form. Hope this is what you had in mind.

query criteria = forms!firstform.datecontrol

Bonnie
http://www.dataplus-svc.com
I have a batch report to run and need the user to select the date to report
for. This does not need a range, simply one date. Currently, I have in the
[BatchDate] column of the report's query the following:

[Enter batch date to run] Or Date()

This works fine, but I would rather have an standard Input box.

The report is currently opened on form [MainMenu] via a button. I am
thinking I should be able to remove the above query criteria in favor of an
input box on the report's open/load event. I don't know how to do that.

Can someone show me the way?

Thanks so much.
 
R

redFred

Thanks. That got me off dead-stop. I do appreciate it.

bhicks11 via AccessMonster.com said:
Create a small form with a control to input the date. In the On Lost Focus
event of that control put your code (or macro) to open the form (or report).
On opening the form (or report) I would put code to set the first forms
VISIBLE option to NO and in the form's (or report's) OnClose event Close the
first form. In the report's datasource query change the criteria to the date
control on the first form. Hope this is what you had in mind.

query criteria = forms!firstform.datecontrol

Bonnie
http://www.dataplus-svc.com
I have a batch report to run and need the user to select the date to report
for. This does not need a range, simply one date. Currently, I have in the
[BatchDate] column of the report's query the following:

[Enter batch date to run] Or Date()

This works fine, but I would rather have an standard Input box.

The report is currently opened on form [MainMenu] via a button. I am
thinking I should be able to remove the above query criteria in favor of an
input box on the report's open/load event. I don't know how to do that.

Can someone show me the way?

Thanks so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top