Data being changed on wrong table

  • Thread starter Thread starter Paul Cooper
  • Start date Start date
P

Paul Cooper

Ok, say I have two tables

<Problem> <Priority>
Problem_class --> Priority_class
Problem_Data_1 etc Priority_desc

I'm using a combo box, populated with every priority_desc
from Priority, highlighting the chosen problem_class from
Problem (plus lots of other data from Problem). If I use
the combo box to change the priority_desc, it changes the
Priority_desc in Priority, rather than updating
Problem_class in Problem - How can I get the combo box to
change the value in Problem, not in Priority??
 
Ok, say I have two tables

<Problem> <Priority>
Problem_class --> Priority_class
Problem_Data_1 etc Priority_desc

I'm using a combo box, populated with every priority_desc
from Priority, highlighting the chosen problem_class from
Problem (plus lots of other data from Problem). If I use
the combo box to change the priority_desc, it changes the
Priority_desc in Priority, rather than updating
Problem_class in Problem - How can I get the combo box to
change the value in Problem, not in Priority??
Click to expand...

What's the Control Source of the combo box? And what's the
Recordsource for the form? (The Control Source should be the field
that you're trying to update; and the Priority_Desc shouldn't be
changing at all).
 
-----Original Message-----


What's the Control Source of the combo box? And what's the
Recordsource for the form? (The Control Source should be the field
that you're trying to update; and the Priority_Desc shouldn't be
changing at all).


.
Click to expand...
That's actually helped! The recordsource was a query that
was pulling back the field from Priority - having changed
that in the query, it now works. Thanks!

Paul.
 
Back
Top