Modifying query expression using VBA

[JR2020610]

I'm trying to find a way to change (overwrite) a query field expression based on a form text input using VBA.  Is this possible?

Ex: Query field expression "ProjectID: 12345"

Enter "20201" in a Form

Update query field expression to "ProjectID: 20201"

[#2 · Accepted solution]

@JR2020610 Yes. it is referred to as "Dynamic SQL" and it is a very common technique for certain tasks.

Actually, I know of one excellent download site where you can get the VBA to do just that. Scroll that page to find "J Street SQL Tools". 

[#3]

@George Hepworth thank you so much.  This looks like a great resource.