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
8/22/2022 - Mon
HainKurt
what about
MessageBox [TempVars]![Combo0]!Text
or
MessageBox [TempVars]![Combo0]!Value
Scott McDaniel (EE MVE )
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!
MessageBox [TempVars]![Combo0]!Text
or
MessageBox [TempVars]![Combo0]!Value