Populating a query based on a text box in a form

[Jessica240]

Hello all.. This seems like a very simple problem, but I can't seem to figure it out. I'm sure this will be an easy one for you experts!




I have a table which shows me the price of a list of items. What I need is to be able to change the price of the items by simply entering in a percentage into an expression which will then change all of the prices in that table by that percent.

Example:

Product Table:

PRODUCT.....PRICE
Hats.......... $20.00

Scarfs.........$10.00

Shoes...........$50.00


So now if I want to find out how much the price would be for all of those items at 90%, I want to be able to type in "90%" into my text box which would produce a table like this:

PRODUCT.....PRICE
Hats.......... $18.00

Scarfs..........$9.00

Shoes..........$45.00


For the field [PRICE] I would have an expression that would be: [PRICE]*[TEXTBOX] where the text box is whatever value the percent would be...


I tried just using a parameter which works for updating the price by percent. But I need to use the results of the table for other queries which then will be used in a report to calculate some other information. When I run my report which is based off of queries that is based off this table, I get a pop-up window that says "The Microsoft Access database engine does not recognize '[ENTER PERCENT]' as a valid field name or expression."


Meaning that it won't let me use the parameter box.

Does anyone have any suggestions?

[ItsMe]

Perhaps a Dynamic Parameterized Query is the solution. You can create an alias in your query by adding a field with something like this

MyNewAmount: [TableName].[PRICE] * [Forms]![FormName].[TEXTBOX]