andrewneal
US Air Force User
- Local time
- Today, 16:05
- Joined
- Sep 19, 2006
- Messages
- 34
I have an application supply file database that will pull a single application list of multiple applicants for a certain job and certain office.
The problem is this report has to pull data from a single table, but several things are playing out in it. I created a form with the following choices for the ASF personnel to filter the report. First the PositionTitle which cooresponds to the PositionTitle on the report. Second, the Activity which cooresponds to the Activity on the report. Third, it must catch everyone who applied for the position title but does not have a preference as to which office they work in. I created, in the drop down list for Activity, an "Any" category for this. So, if the ASF personnel want to pull an applicant report for 'Animal Health Technician' in the SVRV office, then the report should only bring up these applicants and the Animal Health Techncian applicants that did not have an office preference and chose Any instead of an office.
The form ASF personnel will be using to pull this report is made up of dropdown choices for PositionTitle & Activity. The Activity2 field has the default data "Any" in it which I thought I could use to filter the personnel that fall into that category.
Here is what I have created, but it says it is too complex.
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenReport "Referral List", acViewNormal, "", "[PositionTitle]=[Forms]![ReportChoice]![PositionTitle] & [Activity]=[Forms]![ReportChoice]![Activity] & [Activity]=[Forms]![ReportChoice]![Activity2]", acPreview
The problem is this report has to pull data from a single table, but several things are playing out in it. I created a form with the following choices for the ASF personnel to filter the report. First the PositionTitle which cooresponds to the PositionTitle on the report. Second, the Activity which cooresponds to the Activity on the report. Third, it must catch everyone who applied for the position title but does not have a preference as to which office they work in. I created, in the drop down list for Activity, an "Any" category for this. So, if the ASF personnel want to pull an applicant report for 'Animal Health Technician' in the SVRV office, then the report should only bring up these applicants and the Animal Health Techncian applicants that did not have an office preference and chose Any instead of an office.
The form ASF personnel will be using to pull this report is made up of dropdown choices for PositionTitle & Activity. The Activity2 field has the default data "Any" in it which I thought I could use to filter the personnel that fall into that category.
Here is what I have created, but it says it is too complex.
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenReport "Referral List", acViewNormal, "", "[PositionTitle]=[Forms]![ReportChoice]![PositionTitle] & [Activity]=[Forms]![ReportChoice]![Activity] & [Activity]=[Forms]![ReportChoice]![Activity2]", acPreview