Script to change query parameters

[juneau730]

In my dBase, I have three queries that have a parameter that is coded Like"*TUC*"
The dBase is designed to be used by various locations with different location coded. Is there a way to change the query parameter in these three queries via a script?

 

[welshgasman]

Make the parameter a global variable or tempvar and use that instead

Like

SELECT Transactions.Description
FROM Transactions
WHERE (((Transactions.Description) Like "*" & [tempvars]![test] & "*"));