Link to home
Start Free TrialLog in
Avatar of Rakesh Kherajani
Rakesh Kherajani

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.
Avatar of HainKurt
HainKurt
Flag of Canada image

what about

MessageBox [TempVars]![Combo0]!Text

or

MessageBox [TempVars]![Combo0]!Value
Avatar of 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!
ASKER CERTIFIED SOLUTION
Avatar of Rakesh Kherajani
Rakesh Kherajani

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rakesh Kherajani
Rakesh Kherajani

ASKER

worked for me