How to set query parameters from VBA

Giganews Newsgroups
Subject: How to set query parameters from VBA
Posted by:  amorphous999 (jfobrien14…@MAPSON.com)
Date: 16 Aug 2006

I am running Access 2002.  I have some reports I would like to be able to
run from VBA or interactively.  The reports use queries with parameters.
When the user runs the report, the parameter prompts for the query are
displayed, and the user fills them in.  What I would like to do is set
those parameter values from VBA when running the reports.  Is there a way
to do that?

Thanks in advance,

amorphous

Replies