Input box

[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.

 

[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.

 

[redFred]

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

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.