Display query parameter value in message box

[spudracer]

I have a few update queries that will check X number of items, based on what the user inputs.

What I want to do (if possible), is return the number of items selected based on what they type in a message box.

I have set all warnings to false for update queries.

Example:
User runs the "Check Items By Location" query via the form, then receives a message stating "[Total Selected] Items Have Been Selected from [Location]."

 

[spudracer]

I don't have them built in SQL, but I can. I won't be able to get to it until later today.

 

[spudracer]

Here you go.