Printing Form w/ Multiple Subforms

[pbarnes]

I'm running into an error when I print a form that I created. The form itself has 6 subforms fed from the master form (2 field feed), of which 4 of the subforms use the same table.

I am trying to print out each record and I end up with duplicates of certain fields (directly underneath one another) for some of the records. The odd thing is that this does not happen for every record.

I am thinking that I may just want to consolidate the subforms somehow because the complicated nature of the different subforms could be bottlenecking to create an error.

Any thoughts? This is my first post but I'm somewhat experienced with Access (no need to "dumb it down").

 

[boblarson]

Any thoughts? This is my first post but I'm somewhat experienced with Access (no need to "dumb it down").

Yes, for printing create REPORTS. Forms are not built for printing, even though you CAN do it from there, you don't have the control over presentation and all that you do with Reports. So you would build a report and subreports to recreate the form information.

 

[pbarnes]

I had a feeling that you were going to say that. Thanks.

 

[boblarson]

I had a feeling that you were going to say that. Thanks.

Yeah, unfortunately it isn't always easy to get what you need, or want, in Access. So, welcome to the forum and good luck with it all. Be sure to post any other questions you might have.