DON'T WANT TABLE TO UPDATE WHEN CHANGING FORM FIELD

[yimi]

Hi, This cannot be that difficult. What am I doing wrong?!?!?

I have an order subform that contains product details. IE product name, cost,etc. I have a drop down on the subform so that the product can be selected and the price of the product populates. All fine and dandy. The problem is I would like to be able to change the price of the product in the subform without the Products Table changing.

What is happening is when I change the price from $50 (price on the table) to $15, the table price changes to $15 and all records on the form that have that product also change to $15. I only want to be able to change the price for that particular record.

What the #$#$( am I missing?

Thanks for any help

 

[jebry]

Hi!

Your combo box is bound to the table field so each change is reflected in the data. If you unbind the combo box (blank the control source out) then you will not make any changes in the table. If you are going to use a control as a search field then do not bind it to a field. The downside to the unbound combo box is twofold, you will need to add a text box to display the price associated with the current record and you will need to write the code to do the search on the value entered into the combo box. An alternative is to teach your users to work with the find function already in Access (the binoculars on the toolbar or cntl+F) which will search the field for whatever is typed into its box.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[yimi]

Sorry for the late response. Hope your still around Jeff
(or anyone?!?!)

OK here's what I did. I inserted an extra field that is not bound and is input capable for price. I have left the price field in (from the products table) and locked it so that it can not be changed. I've renamed it suggested price. Now the users can see a suggested price and enter that suggested price or a new one in the new field.

New problem. This subform has a datasheet default view. I don't want the suggested price to print out. When I change the "Display When" properties to "screen only" access ignores it and prints it anyway.

Any suggestions?

PLEASE HELP! I'm so tired of looking at this thing!