Update Query that prompts for a percentage change

[Niclasfa]

Hello,



Can someone please help me with this task of setting up a query that when opening should prompt me for a percentage change. I have attached a screen shot of my progress so far. Would really appreciate any feedback or help with this as I need it to finish my assignment that is due in a couple of weeks.

[orange]

Be cautious of your table design. If you record selling price in the Product table, you will lose all history if you change the selling price.

All historic order/sales will be updated to use the new sellingprice. You should consider adding 'AgreedToPrice" and Quantity in the actual OrderDetail record.
That is the Price that that product sold for on this transaction - it could be clearance, loyalty price, negotiated... and will not affect historic Orders.

[June7]

I NEVER use dynamic parameter input popups in query. Can't validate the input. Better to have input on form and query references control on form.

[Niclasfa]

The query needs to be attached to a main menu. It's soul purpose is for when stock prices change by a certain percentage then it will automatically update all stock items based on that change. This will be used rarely. I could create a form based on that query but it would still need to prompt when opening as it will only be opened when any changes to the stock prices will be changed.

[June7]

What do you mean by 'attached to a main menu'? You want a button that will run the UPDATE?

Did you try the UPDATE query you show? What happens? It works for me.