Hello, I am trying to create a command button in a (form style) Subform that generates an html preview report. Here is my problem. First of all, I need to be able to pull all the records from within a date range, say 02/01/2018..02/28/2018, then I need it to generate a report with all the records between that date range (not specific to the record on the Main highest level form). But what happens is, when I press the button the report comes up blank. I then tried to create this same report button on the Main highest level form and targeted it towards the subform, same result, a blank report. Actually, the only time the report works perfectly is when I run it specifically from that application. As in, I opened up the Subform from the application menu in it's own tab, retrieve the records I want, then press the button. However, this does not work for me, I want to be able to run this report on the fly, from within the main application, or rather, the main form. I do not want to have my boss have to open up this other form separately in another tab and have to figure out how to use it and what not. I want them to just be able to push a button like normal. Are there any solutions for this? I was thinking that I might need to run programming from within the report, like GetValues and create a string array or something, then somehow force those into the report, but I really have no idea at this point. As far as reports I only have three commands to work with and I'm not sure how to use those to make it do what I want it to do. As usual, thank you for your time and support.
|