Lock in a Price Quote Form 1

[molly]

I normally have my quote form refer to a table for the latest price for an item. so if i change the price, all my quote records costs instantly change.

But now i have a new need. I do not want OLD quotes to change. I want them to lock in the costs per item.

I am drawing a blank on how to do the latter. I may want to manually change an OLD quote form, now and then, but for the most part, i want the Old quote not to change every time i change the cost price table.

any suggestions to start me in the right direction?
thanks alot.

 

[molly]

Further message. I am saying that i would like my Qry and Form to initially get the present unit cost from a table.

After it does so, i did not want the Qry/Form to seek the unit cost ever again. it would lock in the unit cost. But i would still like to change the cost manually.

Then every 6 months i will update the table with newer unit costs however, the OLD quotes would not change. the Old unit cost would stick inside the qry/form.

any NEW quotes would seek the latest unit cost, and the process continues on.

Is this possible. thanks molly

 

[ck1999]

1. you would have to make a field in your quote table.

2a. an option would be to place a commandbutton on the form for get price and then do a dlookup to get the price from your pricelist. You could also in the commanbutton have a if then to display a caution message if you already have a price in the field and clicked the button by accident.

2b. Instead of a command button you could have it so when qty item name is selected (assuming you are using a combobox) have this fields on_click do a dlookup and place the correct price in the field.

These are some thoughts to hopefully lead you in the correct direction.

ck1999