How to use Docmd.SetParameter ? (1 Viewer)

Docmd.SetParameter

Use the SetParameter method to create a parameter for use by the BrowseTo, OpenForm, OpenQuery, OpenReport, or RunDataMacro methods.


Syntax expression.SetParameter (Name, Expression)
expression A variable that represents a DoCmd object.



Parameter Name: The name of the parameter. The name must match the name of the parameter expected by the BrowseTo, OpenForm, OpenQuery, OpenReport, or RunDataMacro method.


Expression: An expression that evaluates to a value to assign to the parameter.

Click to expand...

Private Sub cmdAddComment_Click()
DoCmd.SetParameter "prmComment", Me.txtComment  

DoCmd.SetParameter "prmRelatedID", Me.txtId  

DoCmd.RunDataMacro "Comments.AddComment"  

End Sub

theDBguy said:

Hi Otto.Welcome to AWF! If you don't mind me asking, why are you interested in the SetParameter method? What are you trying to achieve? From what you have posted, it seems like it's similar to a TempVar.

Click to expand...

SELECT * FROM TableName WHERE ID=[EnterID]

DoCmd.SetParameter "EnterID", 4
DoCmd.OpenQuery "ParameterQueryName"

otto said:

Your assumption and thoughts are gold value and you fulfill your motto Thanks for that.


Analog to the query it works also with forms. If you have a filter in say Form2 like

Code:Copy to clipboard

ID=[EnterID]

And you have a Form1 with a text field txtID and a button btnForm2 then the code for the button in Form1 would look like this

Code:Copy to clipboard

Private Sub btnForm2_Click()
DoCmd.SetParameter "EnterID", Me.txtID
DoCmd.OpenForm "Form2"
 End Sub

Till next time

Click to expand...