Print Form Based on Combo Selection?

phn

Registered User.
Local time
Today, 05:58
Joined
Mar 17, 2006
Messages
21
Hello!

I have almost completed my database, everything I had originally intended to implement into it has been done, with some extra added features I popped in along the way. There is just one more thing I require assistance with...

My database is used for booking camera kits in and out. On the add booking form the user has to pick a "Camera Type" from a combo box. When they have made their selection, a form pops up with details of all of the components contained within the kits. The user can then check/uncheck the relevant components and close the form.

I have used a command button which prints off the data contained within the current booking form, and also the data contained in the form that pops up when the camera type is selected.

However, as there are more than 1 different types of camera, comprising different components, I need to be able to print off the form relevant to the kit type.

I do not know how I can do this as I have just specified the command button to print the form for the default kit.

I basically need some VB code which will print the form based on my combo selection, as my knowledge of VB is pretty primitive, I was wondering if someone could help me out :)

Any help would be appreciated!
 
I'll explain a little more...

img.jpg


As you can see, there is the add form with the pop-up form over the top which appeared after I selected the PD170P kit type.

I could just put a Print button on the form and print from there, but I would like both the booking form and the kit components form to be printed at the same time. I currently only have 2 different "Kit Types" - PD170 (which opens frmPD170, and DSR-450 which opens frmDSR450)

So I need something like:

print frmAddBooking AND [cboKitType] (PD170/DSR450)

Does anybody know if this is possible, and if so HOW?
 
If both the forms are to remain open whilst you print you can do the following

Create a report with no data source add text boxes to the report that mirror the first form and also the second form.

the data source for each field on the report can be based on the corresponding fields on form1 and form2
e.g.
=forms![form1]![field1] etc

place a button on the form and call the report
 

Users who are viewing this thread

Back
Top Bottom