G
Guest
I have a form [frmEvent] based off of a query to run a report. I want the
user to select an event, and then the start and stop date before clicking the
"Run Report" button. The event portion works great using a combo box. In the
query I entered the following criteria:
Like [Forms]![frmEvent]![cboEvent] & "*"
I then have two text boxes on the form [txtBeginDate] and [txtStartDate]. I
can't seem to get these to work. I assumed I would enter the criteria
similar to the events:
Between [Forms]![frmEvent]![txtBeginDate] and
[Forms]![frmEvent]![txtEndDate]
But I just get a blank report.
Also, when I get this to work, I would also like the report the display the
"Between [begindate] and [endDate]" in the report header. I've done this
before using just parameter queries, but it seems to not work when based off
a form.
What am I doing wrong?????
Patti
user to select an event, and then the start and stop date before clicking the
"Run Report" button. The event portion works great using a combo box. In the
query I entered the following criteria:
Like [Forms]![frmEvent]![cboEvent] & "*"
I then have two text boxes on the form [txtBeginDate] and [txtStartDate]. I
can't seem to get these to work. I assumed I would enter the criteria
similar to the events:
Between [Forms]![frmEvent]![txtBeginDate] and
[Forms]![frmEvent]![txtEndDate]
But I just get a blank report.
Also, when I get this to work, I would also like the report the display the
"Between [begindate] and [endDate]" in the report header. I've done this
before using just parameter queries, but it seems to not work when based off
a form.
What am I doing wrong?????
Patti