aaabuhalime
Instructor
Hi ,
I just started anew job, I am dealing with a database that been created by different people, I have a difficulty in opening one of the reports,I have a report called(glowEligibiltyRpt)generated from a query called(QryEigibilty_Post)and a form as well called Eligibility, The query, report the form work as expected. the form and the report are generated from that query,I have a button on the form to open the report, when I open the report a box pops up asking me to enter a parameter value, Enter the Participant ID and the Assessment date, What I want to do is have a command button on a Form that when click occurs the report will open with the records matching the participant Id and Assessment date on the form.
I opens the query I deleted the criteria to stop asking for the parameters, what ever criteria I include in their the parameter box appear again asking for the values, so I need help , again what I need is when Enter the participant ID and the visit date, and click on the button I want open the report with matching records.
Any help will be appreciated,
I just started anew job, I am dealing with a database that been created by different people, I have a difficulty in opening one of the reports,I have a report called(glowEligibiltyRpt)generated from a query called(QryEigibilty_Post)and a form as well called Eligibility, The query, report the form work as expected. the form and the report are generated from that query,I have a button on the form to open the report, when I open the report a box pops up asking me to enter a parameter value, Enter the Participant ID and the Assessment date, What I want to do is have a command button on a Form that when click occurs the report will open with the records matching the participant Id and Assessment date on the form.
I opens the query I deleted the criteria to stop asking for the parameters, what ever criteria I include in their the parameter box appear again asking for the values, so I need help , again what I need is when Enter the participant ID and the visit date, and click on the button I want open the report with matching records.
Any help will be appreciated,