Tearing my hair out with this one. I have a list box on a form with three fields. Two dates and a text field. The text field is always populated but the other two fields may or may not have data in them.
There are three reports that run from these selections. Should also mention that this isn't my database and we're relative novices in this area as well. There are three unbound text boxes on the form that mirror the data selected from the list box, so, when you click on a selection the text boxes populate and this data is then loaded into the report header.
My issue is that only one of these reports pulls the data through from the form (where data is in all three list boxes). If you run either of the other two reports, there is no data in the report header and if you look at the form the data in the text boxes are blank as if the selection has been cleared. Running the report from the three fields, if you check back on the form the data is still held successfully.
I have checked the "on event" properties and there is no difference between the three. We have even tried copying the report that does work and changing it for the other selections and that doesn't work either. There is something going on that I don't understand and wondering if someone of more experience may be able to shed light on why it's not working?
Thanks in advance.
There are three reports that run from these selections. Should also mention that this isn't my database and we're relative novices in this area as well. There are three unbound text boxes on the form that mirror the data selected from the list box, so, when you click on a selection the text boxes populate and this data is then loaded into the report header.
My issue is that only one of these reports pulls the data through from the form (where data is in all three list boxes). If you run either of the other two reports, there is no data in the report header and if you look at the form the data in the text boxes are blank as if the selection has been cleared. Running the report from the three fields, if you check back on the form the data is still held successfully.
I have checked the "on event" properties and there is no difference between the three. We have even tried copying the report that does work and changing it for the other selections and that doesn't work either. There is something going on that I don't understand and wondering if someone of more experience may be able to shed light on why it's not working?
Thanks in advance.