Use Combo Box selection in a calculation

[sra2786]

I am new to Access and I need to use the value selected in the Combo Box in a calculation in my query results. I saved the value in a VBA global variable but then I cannot figure out how to use this VBA global variable in my calculation. There just seems like there should be an easier way to do this but I have been unsuccessful in searching for a solution or trying to figure one out on my own.

Any help would be appreciated.

[ohmydatabase]

You can use the OnChange Event to define the value of your global variable every time the value of the ComboBox changes. After you define the variable you can also write a bit of code within the OnChange Event to do the desired calculation. (store result in a new variable) Using the result of your calculation, you can assemble an SQL String within VBA that you can then use as a RowSource or whatever else you need an SQL Query for.

There's a pretty good learning curve on this stuff, but once it clicks you'll start making lots of progress. I hope this helps, good luck.

[orange]

You can use the value from the textbox directly in the query--unless there is some need for the global variable.

In general, something along this
eg. SELECT some fields from YourTable
Where someField = Forms!YourFormname!yourcomboBox

[sra2786]

I want to use the value entered in the combo box in a new field in my query with a calculation

NewField = Forms!YourFormname!yourcomboBox * 10

[orange]

What is the SQL of your query?

[ohmydatabase]

I want to use the value entered in the combo box in a new field in my query with a calculation

NewField = Forms!YourFormname!yourcomboBox * 10

Something you could do is put some VBA on the OnChange Event that runs the SQL Query that @orange is talking about. It seems that you need a "kicker" to trigger either: the value of your ComboBox be added to some table, or to assemble an SQL Query in VBA, which you execute and do any calculation you need.

I do like @oranges method. If you're using to Query Desinger instead of VBA than I can't really speak on this. I essentially do everything in VBA..