Data being changed on wrong table

[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??

 

[John Vinson]

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??

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).

 

[Paul Cooper]

-----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).


.

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.