Access2003: "Print Current Form":Subfrm woes?

[NTeyeball]

Hey all,
I really appreciate the work this site provides in helping selftauts. Thanks all,

Access 2003:

I have a form [Invoice] that has [Tbl_Clients] as source and a Subform sourced by [Tbl_Jobs], thus the main form scrolls thru clients and the subform scrolls thru jobs for each client.

Now I goto print the current form!!
I have tried a CmdButt wizard+open currentform, and File/Print/Selection

Both are fine on the first "Jobcard" but past 1, they all print weird.
Imagine the page portrait, upper half has client info, the lower half has the subform Jobs. Then a "Footer".
When printed, the lower half tries to print sequential subforms THRU the footer???
The "File/Printpreview" shows the invoice correctly.
Maybe I have approached this wrong?
After thought and rumaging, Maybe I need Frm with no subform, which would be good if I new how to Autofill client details via combobox selection of client names. And just manually fill Job details. Then Print??

Any help appreciated!!
NT

 

[John Big Booty]

Welcome to the forum.

What you really need to do is to create a report that replicates the feel of your form and then print that.

You would need to create a query that uses;

Forms!YourFormName!RecordID

as criteria, this would then populate your Report with the data relevant to the currently displayed record. You would need to replace RecordID with the name of a control on your form that is unique to the current record.

 

[vbaInet]

After thought and rumaging, Maybe I need Frm with no subform, which would be good if I new how to Autofill client details via combobox selection of client names. And just manually fill Job details. Then Print??

Maybe you need to be printing a report and not a form.

Edit: I didn't see your post there JBB. We speak the same language.

 

[NTeyeball]

Thanx guys for the quick response,
I was not aware that a report can do calc?, as the said form does.

I shall investigate.
NT.

 

[John Big Booty]

As a quick run down. Your tables store your data, and your user should have no direct interaction with the tables. Forms allow your user to interact with the data stored in the tables. Reports allow your user to create hard copy representations of the data. Whilst Queries allow you to manipulate the data for display in either forms or Reports.

 

[vbaInet]

... and reports and forms have almost identical properties and methods. So whatever you can do in a form it's almost likely you can do it in a report too with the exception of data manipulation to a great extent of course.