form printing for no good reason....

[CHAOSinACT]

I'm so lost on this one. I have a claim form; you fill it in, hit submit and it copies data to the report for printing. the only way to do it is in dialog mode; i need background code to halt while they fill in the form and wait for the submit button to be pressed. frankly, i'm having trouble loading the data in the report from the form but i feel sure that a Me.Visible = false should allow the reports "form_current" event to grab it. still haven't been able to prove that theory but working on it (perhaps you will see another post about that if i fail lol).

at this point, i open the report like this:

DoCmd.OpenForm "frmClaimLodgementForm", acNormal, , , , acDialog

then the Me.Visible in the submit button stuff

then it comes back to this:
DoCmd.OpenReport "rptClaimLodgementForm", acViewNormal

so the report can load the data. for some reason i can't fathom
DoCmd.OpenReport "rptClaimLodgementForm", acViewNormal
prints the report INSTEAD OF OPENING IT. dead set there isn't print command anywhere!!! i just want the dumb report to open. Ideas anyone????
I'm running out of paper here.

thanks in advance....

 

[the_net_2.0]

The Docmd for opening a report prints it automatically when you open it in Normal mode. You may want to try using acViewPreview instead.

 

[CHAOSinACT]

The Docmd for opening a report prints it automatically when you open it in Normal mode. You may want to try using acViewPreview instead.

really? huh. i guess in 99% of situations i open a report in print preview. never noticed this till now! thanks. something tells me i will be back here soon lol...