Unanswered: Opening multiple reports from a form in Access 2000
Hi all, I'm doing a little project for work for a card printing program I'm making.
The situation as it stands now is 4 different reports, all different types of cards. One of our clients fire me through a database with the require data and embedded photo's and signatures. The reports are set up so I can open them each seperately and will print perfectly each time.
But I've built a form which will simplify the process, as it can get kind of messy working with reports seperately! In the table the client sends me there is a field called "CardType" and they specify which card it is. Most of the time there are multiple card types in the one table. What I want is one command button on the form that looks at that field and determines which report to open. And on top of that, I want it to look at the whole field, not just the first record... It's looking at the first record at the moment when I use an If Then Else statement. So it opens the first one, then pops up an error!
How do I make it open all of the reports corresponding to the table?