M
markmarko
Hello,
I'm trying to use a temporary variable to keep track of which CSR is
inputting data.
I have a macro which prompts user for ID code, which is stored in the temp
variable TempUser.
On a form control default value property, I can use the expression
[TempVars]![TempUser], which will populate that user's ID code into the
control.
However, I cannot use that same expression in the tables field default value
property. If I try, when I save the changes to the table, I get the error
message "Could not find the field 'TempVars]![TempUser'. "
Any ideas why I can't use that in the table field default property?
Thanks!
I'm trying to use a temporary variable to keep track of which CSR is
inputting data.
I have a macro which prompts user for ID code, which is stored in the temp
variable TempUser.
On a form control default value property, I can use the expression
[TempVars]![TempUser], which will populate that user's ID code into the
control.
However, I cannot use that same expression in the tables field default value
property. If I try, when I save the changes to the table, I get the error
message "Could not find the field 'TempVars]![TempUser'. "
Any ideas why I can't use that in the table field default property?
Thanks!