I have a "Stock Check" report that has a running sum and has a filter attached to it.
Works perfectly.
I also have a form that allows the user to adjust the stock level.
What I want is to put the report as a subreport into the form, so the user can see the current stock level.
I have the report in as a subreport but am struggling to link the two together.
When I open the form it asks for the product code, which is through the query attached to the report. So I get the right data in the subreport, but the fields in the form are blank waiting for me to fill them in. Is it possible to get the supplier and product field to get its data from the subreport?
Hope that makes sense.
Works perfectly.
I also have a form that allows the user to adjust the stock level.
What I want is to put the report as a subreport into the form, so the user can see the current stock level.
I have the report in as a subreport but am struggling to link the two together.
When I open the form it asks for the product code, which is through the query attached to the report. So I get the right data in the subreport, but the fields in the form are blank waiting for me to fill them in. Is it possible to get the supplier and product field to get its data from the subreport?
Hope that makes sense.