Making 2 separate queries use the same prompt

[zigman02]

I have a report within Access that draws off 2 separate queries. The queries have the exact same prompt and the result you type in is the same for both. Is there a way to only be prompted once and have both queries recognize it?

This is the code:

Private Sub Command7_Click()
On Error GoTo Err_Command7_Click

Dim stDocName As String

stDocName = "List Search"
DoCmd.OpenReport stDocName, acPreview

stDocName = "List Search 2"
DoCmd.OpenReport stDocName, acPreview

Exit_Command7_Click:
Exit Sub



Err_Command7_Click:
MsgBox Err.Description
Resume Exit_Command7_Click

End Sub

Both "List Search" and "List Search 2" have a prompt that says "enter search criteria

 

[Remou]

You could use a form, then each query would have criteria like this:
Forms![Form Name]![TextBoxName]