Experts,
I have a frmDateRange and have 2 fields: txtDateFrom and txtDateTo
I have a button on frmDateRange that opens rptAvailable.
In the rptAvailable record source, the query parameters refer to the form's values as found in frmDateRange.txtDateFrom and frmDateRange.txtDateTo.
(ie: >=[forms]![frmDateRange]![
txtDateFro
m] And <[forms]![frmDateRange]![t
xtDateTo]+
1 And Is Not Null)
I know it is better to pass the date ranges via the button on the form i/o loading the criteria into the report via a parameter query.
How can I load the criteria and open the report by way of the button on the frmDateRange?
following is what I think you might need:
frmDateRange
txtDateFrom
txtDateTo
rptAvailable
Thank you
let me know if you need something else
here is the frmDateRange:
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.