This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi, I have created a form in access 2010 called "customer profile" on the form I have 2 reports that I created and dragged onto the form "Credits" and "Denials"
On my 'customer profile' form I have a search button where when we enter the customer number of a client the information regarding that specific client populates on the (subreports) on the form 'Credits and Denials'.
When we go to print the reports for the specific customer the criteria changes and ALL customers start to print rather than the specific customer we searched for.
How can we fix this, please help
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Here's the thing. I can't visualize a form that would display subreports in a manner that would provide an at a glance profile. However, I can visualize using a form and subforms to do so. I think you need to relook at this.
Well the whole reason the reports are on the form is so that when investigating a customer all the information is shown on one form right in front of you. After inputting a customer 6 different reports populate giving an array of information and saving time rather than selecting one report to view at a time, and again some reports we may not need to print, viewing and cross referencing information may be sufficient enough.
Again in thank you so much for your help I couldn't have done this without you my friend!
Cheers
One other question,if I change the control bound to CustNo do I just delete the
Me!Text25=Null?