Exclude subform from printing

[biggcc]

Need to know if there is a way to exclude a subform from printing when I print forms?

Here's what I'm trying to do - Have a form that contains multiple subforms that are linked back to the master form. One of these subforms is a memo which they would like to see on the "preliminary or draft" copy of this form but would like to exclude it from the "final" copy.

I would think there is some why to do it but I'm stumped at the moment.

Any ideas would be greatly appreciated.

Thanks,

 

[biggcc]

Exclude subform

Thanks Pat but I need to use this form unless there is a way to setup a button on the form that will transfer the current record to the report and print it.

This is for upper management and they want to see the data and push a button. Not enter items on the form then go out and find the report and print it.

If there is a way to do it all directly from the form screen then that would be great.

Any ideas please let me know.

Thanks

 

[ghudson]

I also have a need to print a form in a few apps. To not have the subform print when you print the form you need to make the subform not visible when you print.

Me.YourSubFormName.Vivisble = Flase
DoCmd.RunCommand acCmdSelectRecord
DoCmd.PrintOut acSelection
Me.YourSubFormName.Vivisble = True

 

[biggcc]

Thanks ghudson.

I have a question with your solution. Haven't tried it yet but need to know if I can make it visible or invisible dependent upon a choice say like a toggle switch on the form?

Also I have another question which is on the same form. I have multiple subforms within this form and form some reason if there is no data for the subform it will not print a blank "place holder" for the subform. It shows it on the screen but will not print it. Strange.

If I should post it as a different question please let me know.

Thanks

 

[biggcc]

Thanks Pat.

I'm giving your suggestion a try but my weak point with Access is VB. With regards to your line "SomeKeyField = " & Me.SomeKeyField would I refer to one of my table fields? I have tried multiple different combinations and nothing seems to work. Let's say I wanted it to key off my lastname field - How would that go in this line?

I know it's a stupid question but once answered it will never be asked again.

Thanks