smallWorld
Registered User.
- Local time
- Tomorrow, 05:12
- Joined
- Jan 10, 2008
- Messages
- 15
Hi to all,
I'm using a Access 2003 form to access a query that'll be used to generate a report. The example I'm following is found in http://office.microsoft.com/en-us/ac...CL100570041033.
On my form, I have a combo box (Course ID), textbox (StartDate) and textbox (EndDate).
In my query, I'm using the values from the above 3 controls as criteria.
E.g.: In the Course_Date field in my query, I used Between [Forms]![Form_Name]![StartDate] And [Forms]![Form_Name]![EndDate] as the criteria.
If I leave the form controls blank,and click on the OK button, it'll generate a report with errors. What should I do if I want to generate a report that display all records in the report? E.g.: If I select a course in my combo box and leaves the start date & end date blank, it'll generate a report that displays all records for that particular course.
Thx!
I'm using a Access 2003 form to access a query that'll be used to generate a report. The example I'm following is found in http://office.microsoft.com/en-us/ac...CL100570041033.
On my form, I have a combo box (Course ID), textbox (StartDate) and textbox (EndDate).
In my query, I'm using the values from the above 3 controls as criteria.
E.g.: In the Course_Date field in my query, I used Between [Forms]![Form_Name]![StartDate] And [Forms]![Form_Name]![EndDate] as the criteria.
If I leave the form controls blank,and click on the OK button, it'll generate a report with errors. What should I do if I want to generate a report that display all records in the report? E.g.: If I select a course in my combo box and leaves the start date & end date blank, it'll generate a report that displays all records for that particular course.
Thx!
