Creating Queries

[Jengo]

How to I modify queries.&nbsp;&nbsp;For example I have a query already made call qry1.&nbsp;&nbsp;But I need the query to change depending on who(different users) uses it.&nbsp;&nbsp;How to I call to the query to change the finding text.&nbsp;&nbsp;Example:<br><br><br>Field:&nbsp;&nbsp;&nbsp;&nbsp;Data<br>Table:&nbsp;&nbsp;&nbsp;&nbsp;Data_Table<br>Show:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Yes<br>Criteria: &quot;Bob&quot;<br><br>I want to change &quot;Bob&quot; to &quot;Mike&quot;?

 

[Can]

Uses Parameters.&nbsp;&nbsp;EX.&nbsp;&nbsp;in your criteria, use something like [Name], that will cause the qry1 to stop and ask for the parameter.