asked on
Microsoft Access
Hi All,
I am trying to build a Microsoft web database to automate some of the tasks in our team.
In the process, I am facing some issues in creating temp variable and storing the value of combobox in the variable. The process followed by me is as below:
On the Combobox After Update event, run macro SetTempVar Name : LocationCombo Expression = [Combo0]
MessageBox [TempVars]![Combo0]
I am trying to run the message box to see if the variable is captured correctly but it throws the expression (TempVars!Combo0) as a string instead.
Appreciate if someone can help on the query.
I am trying to build a Microsoft web database to automate some of the tasks in our team.
In the process, I am facing some issues in creating temp variable and storing the value of combobox in the variable. The process followed by me is as below:
On the Combobox After Update event, run macro SetTempVar Name : LocationCombo Expression = [Combo0]
MessageBox [TempVars]![Combo0]
I am trying to run the message box to see if the variable is captured correctly but it throws the expression (TempVars!Combo0) as a string instead.
Appreciate if someone can help on the query.
DatabasesMicrosoft Access
Last Comment
Rakesh Kherajani
Also note that Access is retiring AWAs, so you might rethink your use of them. They're moving to PowerBI instead, and if history is any indication there won't be a conversion tool!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
worked for me
MessageBox [TempVars]![Combo0]!Text
or
MessageBox [TempVars]![Combo0]!Value