need to have subform edit main form data without error

[Robertt]

I have a subform on a parent form's tab control, that has a bound checkbox to a child record. In the checkbox's onClick event, I need it to change two fields' values on the parent form (but on another tab). Coding the path to the objects hasn't been a problem except that no matter what I try, the moment I move out of the subform to the parent form, change records or save, I'm given the error "this record has been changed by another user... do you want to save, blah, blah, blah"

I thought by linking the main form and the subform, this message was supposed to be eliminated, but it has been problematic at best. I know I can make all of my controls unbound, but that would be time consuming and create new problems.

Someone here must have ran into this before and solved it simply. Does anyone have any suggestions that they have used before?

Thanks,



Robert

[pbaldy]

The "usual suspect" when you get that error is that you are trying to change values in code when a form or subform bound to the same table is open and dirty. The solution is typically to change them on the form instead of via recordset or SQL. How are you changing the values?

[Robertt]

Paul,

Thanks for the reply. I'm changing the values via the forms, not the recordset. I.e. the code in the subform onClick event is...

    Forms!frmPropertyDetails!Occupied.Value = Me.chkoccupied.Value
    Forms!frmPropertyDetails!propMargin.Value = valueB

valueB is a variable.

I've also verified that my mainform/subform's recordsets are using the other's recordsets accidentally through a join of some type.

I've been fighting this for a couple of weeks and any help would greatly be appreciated.

Thanks,

Robert

[pbaldy]

I assume you mean they are not using each other's recordsets? Can you post the db?

[Robertt]

Paul,

Yes, that is what I meant to say. Sorry for not being clear. Unfortunately, no I cannot publish the DB due to an NDA with the client.

Robert