kda1234 said:
I need to have the user input the date and time of a meeting so that I can
use the date to extract only data on or before that date and also to include
the date on the report along with the time of the meeting.
There are lots of ways to do that. What might be best for
you depends on your situation.
Just for starters, the most common approach for beginners is
to use what's called a parameter prompt in the report's
record source query. (If the report is based on a table,
then create a query for the fields in the table and change
the report to use it.) In the Criteria row of the meeting
date field, add a prompt string such as
[Enter meeting date]
When the report is opened, this will cause a popup box to
prompt for a meeting date value, which will then be used to
filter the data.
A text box on the report can display the entered value by
just referencing the prompt string the same as if it were
any other field in the query.
A better, but a little more advanced, approach would be to
use a form with a text box for the user to enter the date.
a command button on the form would then use that value in
the OpenReport method's WhereCondition argument.
