Hello,
I have created a report that will act as a calendar. It contains 35 unbound text boxes and 35 subreports. Each subreport is linked to one of the text boxes.
Now, the idea is to populate the text boxes with dates upon opening the report. The subreports will then each disply the appropriate info based on each text box's date!
Pretty spiffy all in all, and it works, KIND OF. I've had to put the code that populates these text boxes into the Detail_Format event. This works fine, it does what I need it do, BUT, when I first open the report, the subreports don't get filled. If I switch to design view, and then preview again, it's fine. Or if I print the report after first previewing it, it's fine.
I guess the subreports get created before the text boxes get filled the first time through, which is my dilemna.
I tried putting this code into the Report_Open event, but get an error saying "You cannot assign a value to this object".
I'm soooo close to having a spiffy calendar report here. Does anyone have any insight into how I can get those darned text boxes populated on the first try??
Thanks so much,
Gord
I have created a report that will act as a calendar. It contains 35 unbound text boxes and 35 subreports. Each subreport is linked to one of the text boxes.
Now, the idea is to populate the text boxes with dates upon opening the report. The subreports will then each disply the appropriate info based on each text box's date!
Pretty spiffy all in all, and it works, KIND OF. I've had to put the code that populates these text boxes into the Detail_Format event. This works fine, it does what I need it do, BUT, when I first open the report, the subreports don't get filled. If I switch to design view, and then preview again, it's fine. Or if I print the report after first previewing it, it's fine.
I guess the subreports get created before the text boxes get filled the first time through, which is my dilemna.
I tried putting this code into the Report_Open event, but get an error saying "You cannot assign a value to this object".
I'm soooo close to having a spiffy calendar report here. Does anyone have any insight into how I can get those darned text boxes populated on the first try??
Thanks so much,
Gord
