Hi PM, I would go to Help and look up the OpenReport Method. There are all the examples and options there to get you started.
The other way is to open any of you forms in design view, make sure the Wizard button (stars and wand) on yout Toolbox is checked and then drop a command button onto your form. This will open the wizard from where you can select Report Operations and then fill in the parameters. Once that's dne, you can look at the code it creates and get an idea of how it works and how you will be able to further modify it for any special needs. Brett prat85635 wrote: > Hi all, > > can anyone please tell me how to open an access report using vb code > and pass parameters to the report. > > Thanks > PM > > -- Brett Collings Strengthening Families Administrator D2D 46422 DDI (04) 916 3422 ------------------------------- This email message and any attachment(s) is intended only for the person(s) or entity(entities) to whom it is addressed. The information it contains may be classified as IN CONFIDENCE and may be legally privileged. If you are not the intended recipient any use, disclosure or copying of the message or attachment(s) is strictly prohibited. If you have received this message in error please notify us immediately and destroy it and any attachment(s). Thank you. The Ministry of Social Development accepts no responsibility for changes made to this message or to any attachment(s) after transmission from the Ministry. ------------------------------- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/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/
