Hello,
I am currently experiencing issues with dynamically generating a report based on a query & form. :banghead: I am hoping someone can help out.
I essentially want to be able to generate a report based on user selection within a combo box on a form that stores the industry of my client. So for example, if the end user selects industry "Insurance", the report would list out all of the records that are tagged as Insurance.
Step 1:
I created a query ("query - search industry") that searches my main table. The fields I am pulling in are:
----------------
ClientID (PK)
Client Name
Industry
Domain
Page Type
----------------
Step 2:
I created a report using report wizard ("report - Client by Industry") that references this query. Format is exactly how I want it to be.
Step 3:
I created a form ("Form - Search Industry") that has an unbound combo box (IndustryCMBX). That combo box references an independent table that holds all of the different industry types (Insurance, healthcare, etc...). Next I have a button. That button was setup using the wizard and its action is set to "openReport" and I reference report "report - Client by Industry".
Step 4:
I update my query to accept the value of the industry field, for example:
[Forms]![Form - Search Industry]![IndustryCMBX]
This approach seems to work for some many other users, but for some reason, not me.
Anyone have any ideas as to why I am having issues?
NOTE:
I will also mention that I used a bound combo box previously based on a field within my original table and that worked, however whenever I selected an option from the combo box and clicked the button, the result would display, but it would actually edit the first record of the underlying table. For example, lets say the first records industry was Healthcare, if I selected Insurance in my form and clicked the button, the first record would be updated with Insurance instead of healthcare.
Any help anyone can offer would be much appreciated!
I am currently experiencing issues with dynamically generating a report based on a query & form. :banghead: I am hoping someone can help out.
I essentially want to be able to generate a report based on user selection within a combo box on a form that stores the industry of my client. So for example, if the end user selects industry "Insurance", the report would list out all of the records that are tagged as Insurance.
Step 1:
I created a query ("query - search industry") that searches my main table. The fields I am pulling in are:
----------------
ClientID (PK)
Client Name
Industry
Domain
Page Type
----------------
Step 2:
I created a report using report wizard ("report - Client by Industry") that references this query. Format is exactly how I want it to be.
Step 3:
I created a form ("Form - Search Industry") that has an unbound combo box (IndustryCMBX). That combo box references an independent table that holds all of the different industry types (Insurance, healthcare, etc...). Next I have a button. That button was setup using the wizard and its action is set to "openReport" and I reference report "report - Client by Industry".
Step 4:
I update my query to accept the value of the industry field, for example:
[Forms]![Form - Search Industry]![IndustryCMBX]
This approach seems to work for some many other users, but for some reason, not me.
Anyone have any ideas as to why I am having issues?
NOTE:
I will also mention that I used a bound combo box previously based on a field within my original table and that worked, however whenever I selected an option from the combo box and clicked the button, the result would display, but it would actually edit the first record of the underlying table. For example, lets say the first records industry was Healthcare, if I selected Insurance in my form and clicked the button, the first record would be updated with Insurance instead of healthcare.
Any help anyone can offer would be much appreciated!
