Joe- Forms are primarily for viewing on screen and editing. If you want to directly print something, build a report. It is possible to open a form in Print Preview (acViewPreview), but there's no way to directly print it. I suppose you could open it in Print Preview and then try RunCommand to print it, wait a few seconds, and then close it. But you really should avoid all this bother and build a report to print your data.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Tuesday, December 06, 2005 1:58 PM To: [email protected] Subject: [ms_access] Re: ? on Print button on form to print another form Hi John, The form does open using the command: DoCmd.OpenForm "iraprovalformprint", acViewNormal under a button ,but what I'd like to do is send the above form directly to print,then close? Joe --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Joe- > > First, the query should be: > > PARAMETERS [Forms]![irneedaproval]![iralist] int; > SELECT [Incident Query].* FROM [Incident Query] > WHERE ((([Incident Query].ID)=[Forms]![irneedaproval]![iralist])); > > The second form should open just fine as long as the irneedaproval form is > open and the iralist control has a value. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of eliotchs > Sent: Tuesday, December 06, 2005 11:40 AM > To: [email protected] > Subject: [ms_access] ? on Print button on form to print another form > > Hi, > > Now that I have my listbox working(Thanks John!) > I'm trying to setup a button on the form which sends a different form > to the printer. > Form that opens = "IRneedaproval" it gets its record from > SELECT [Incident Query].*, [Incident Query].ID FROM [Incident Query] > WHERE ((([Incident Query].ID)=Forms!irneedaproval!iralist)); > > the button is sent to open "irneenaprovalPrint", using the same record > source above. > > The problem is it print blank. > I think I need to pass the ID somewhere? > > Thanks In Advance > > Joe > > > > > > > > > > Yahoo! Groups Links > Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
