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 Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/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/
