You can't assign a value to this object./2448

[Ronald W. Roberts]

You can't assign a value to this object./2448

I'm using Access 2000.
This form is designed to transfer ownership of some child
records from one owner to another. What I want to do is
show the original owner record as a transfer status and have
a pointer pointing to the new owner record.

I have a main form and a subform. On the subform I have a
click button that updates 2 other tables, then tries to change
a text field on the main form from "Active" to "Transfer".

The only unique thing I can see is the record source of the
Main form and the SubForm are the same table, "OwnerMaster".

Parent is : SectionNo; LotNo; OwnerNo
Child is : SectionNo; LotNo; TranaferFromOwnerNo

Why can't I change the value in the control on the main form?

Ron

 

[Jonathan Parminter]

-----Original Message-----
You can't assign a value to this object./2448

I'm using Access 2000.
This form is designed to transfer ownership of some child
records from one owner to another. What I want to do is
show the original owner record as a transfer status and have
a pointer pointing to the new owner record.

I have a main form and a subform. On the subform I have a
click button that updates 2 other tables, then tries to change
a text field on the main form from "Active" to "Transfer".

The only unique thing I can see is the record source of the
Main form and the SubForm are the same table, "OwnerMaster".

Parent is : SectionNo; LotNo; OwnerNo
Child is : SectionNo; LotNo; TranaferFromOwnerNo

Why can't I change the value in the control on the main form?

Ron

.

Hi Ron,
most likely due to record locking conflict.

You will have to reconsider your design of either your
table relationship (you seem to have one table related to
itself!) or the design of your form (is it possible to
just have the main without a subform?)

Luck
Jonathan

 

[Ronald W. Roberts]

Thanks,
That's what I was thinking when I sent the e-mail.
Just wasn't sure.

Ron