Want to do Manual Edits to Combo Currency Fields

[skin76]

Hello
I have a main form with a subform. On my subform I have a combo box that has pre-defined ProductNames, Cost and Sell Prices.

When I select a product from my combo box the pre-defined cost and sell amts are entered into their fields.

The problem I am having is when I manually edit the cost and sell amts all of my previous record are changed to the amt I just entered, and when I go to add a new record that amt I manually typed in is inside of the combo box

So my question to you is, how can I edit my pre-defined amounts that is attached to my combo box, save that amt to that current record and all of my previous history stays unharmed and when I go to a new record my pre-defined amts are at there original state.

Please Help Very Urgent

 

[mph1]

Do you have your cost and sell amount in seperate tables? They should be. If they are, have your combo box based on these tables. You can also set up fields in the main table as foreign key to record this info. If this type of concept is used then you should not have a problem.


HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[PHV]

skin76, be aware that unbound control value in a continuous form stand for all record displayed.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[skin76]

Guys thanks for your help.Everything is working like I want it to.

Thanks You