gazdzid
asked on
Access Forms Queries
I do not want the second form to query due to no paramaters entered (seems like On Open might help but not sure how to do it).
What I would like is to access the second form from the main page and have the two reports below show zero record (without going throught the query process).
How the database currently works
Step 1 - From main page "Button One-Components is pressed.
Step 2 - Form "Component Form Page" is opened.
Step 3 - Access automatically runs Query 1 and Query 2 as a means to populate Report 1 and Report 2 even though there are no parameters (wastes time).
Can you help?
Main Form
Submit Button
Second Form "Component Form Page"
Report 1 Query 1
Report 2 Query 2
What I would like is to access the second form from the main page and have the two reports below show zero record (without going throught the query process).
How the database currently works
Step 1 - From main page "Button One-Components is pressed.
Step 2 - Form "Component Form Page" is opened.
Step 3 - Access automatically runs Query 1 and Query 2 as a means to populate Report 1 and Report 2 even though there are no parameters (wastes time).
Can you help?
Main Form
Button one - Components
Submit Button
Second Form "Component Form Page"
Input One
Input Two
Report 1 Query 1
Report 2 Query 2
Upload a sample database and direct us what to do to experience the problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Topics: Microsoft Access Database ,MS SQL Server
Does this question have anything to do with MS SQL Server?
Does this question have anything to do with MS SQL Server?
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Accept: Scott McDaniel (Microsoft Access MVP - EE MVE ) (http:#a40196535)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
MacroShadow
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Accept: Scott McDaniel (Microsoft Access MVP - EE MVE ) (http:#a40196535)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
MacroShadow
Experts-Exchange Cleanup Volunteer