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.
DatabasesMicrosoft Access

Avatar of undefined
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!
ASKER CERTIFIED SOLUTION
Rakesh Kherajani

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Rakesh Kherajani

ASKER
worked for me
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes