UPDATE not wanted via FORM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(in ACCESS 2002) My form CHARGE gets information via a combo box {A} which
looks-up from Query CONTRACT (which is linked to a Query INVOICE) to get
required information. My second combo box {B} also looks-up inforamtion from
Query CONTRACT. However, when the form record is saved it updates ny query
CONTRACT which should not be the case as I have set the properties Limit to
List as Yes. Anybody can explain why my form updates the table call CONTRACT?
 
Sounds like the form's query includes the table referenced by the combo. In
that case, you need to set the locked property to yes for all the visible
fields from the lookup table to prevent them from being changed accidentally.
 
Hi Pat,

I am not sure what you mean. Both combo boxes read from the same query.
combo box A on click drops down the person i need and combo box B drops down
the related information I need for the requested information of the selected
combo box A. So far so good. However it does update my table CONTRACT which
i do not want it to do even thought the properties is set to YES limited to
list
 
I guess I don't understand what you are trying to do. Why do both combos use
the same RowSource query?

Bound controls update the form's Recordsource when they are changed.
Unbound controls don't. If you don't want the combo's selection to be saved,
remove the field name from the combo's ControlSource property.
 
Pat,
I did remove from the controlsource the field name but then the next field
did not automatically update the required information unless i entred
manually which is not my case. All I can tell you now its working correctly
BUT I have no idea why or what I have done. Thanks for your help any way
 
Back
Top