Subform update issue

[Tskutnik]

All (Thanks in advance BTW),

• I have a Parent Form with embedded Subform in Datasheet format. The Parent and Sub are linked correctly, with a field called ClientNumber.
• Each Parent Form has its woen record, by ClientNumber. The embedded datasheets (correctly) show all the invoices for the Parent's ClientNumber, of which there are many for each ClientNumber.
• In the Datasheet there is a field called Status.

Problem: As I update the Status field in a specific row in the Datasheet all the other rows in that same Datasheet (for the given ClientNumber shown) update.

BTW - when I open and use the Subform by itself the Status field updates work fine.

I'm sure I'm missing a Property setting somewhere.
Thanks

 

[bob fitz]

Is the "Status" control on the sub form bound to a field in the forms record source.

 

[Tskutnik]

Bob -thanks.
The SubForm's Status field is bound to a seperate table with a list of options for the Combo Box selections.

 

[spikepl]

That was not an answer to the question asked.

OPen the properties of the combobox and say what ControlSource property is. It is probably empty - which means the control is unbound and hence produces the result you described in your first post.

Combos may have a Row Source - that is where the second table comes into play.

 

[bob fitz]

Bob -thanks.
The SubForm's Status field is bound to a seperate table with a list of options for the Combo Box selections.

Not sure what you mean. Can you show us the SQL statement for the forms Record Source.

 

[Tskutnik]

spikepl:
The Control Source for the Combo was empty. If I change it to "Status" (the field in the underlying table) then the Subform will not take any updates at all.
The Row Source property contains the options in the Table from which the combo reads - in other words - the combo reads from the table StatusCombo which has 10 different rows, each with a different status, from which the user selects

Bob:
From the Subform as requested....
SELECT Invoice.InvoiceID, Invoice.ContactName, Invoice.RequirementID, Invoice.Status, Invoice.Recruiter, Invoice.DateAdded
FROM Invocie LEFT JOIN Contacts ON Invoice.ContactName = Contacts.ContactFullName;

The Parent and SubForm are linked through the InvoiceID field.

 

[Tskutnik]

Bob
Sorry I meant Parent and SubForm are linked through the RequirementID. Not InvoiceID.
I assume you wanted the SQL from the SubForm and not the parent? Thats what I sent.

 

[bob fitz]

Can you post a copy of your db