sql - TempVar use in query -

so client has 4 queries need updated every time process run.

i setting macro ask user input on variable called 'filedate'.

here's how looks:

settempvar     name = filedate     expression = inputbox("enter filedate (yyyymmdd):") 

now works fine ( can tell )

then wanted use messagebox display value of tempvar, since it's in same macro, didn't see problem this.

messagebox     message = "you entered:" & [tempvars]![filedate] & "."     beep = yes     type = informative     title = input 

i've tried several variations of syntax no progress...

issues

i can't messagebox show value set variable, displays message - know proper syntax messagebox?

once figure out, i'd enter input box once, , insert variable each query requires update.

currently i'm accepting user input every query:

update test_pcp_changes set test_pcp_changes.datercvd = [enter filedate (yyyymmdd): ] (((test_pcp_changes.datercvd) null)); 

i'd like:

update test_pcp_changes set test_pcp_changes.datercvd = [tempvars!filedate] (((test_pcp_changes.datercvd) null)); 

but not sure how pass query. assume once it's in macro, long don't remove it should available long access open..

anyone know i'm missing?

change message on messagebox start =.