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

  • Thread starter Thread starter Ronald W. Roberts
  • Start date Start date
R

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

.
Click to expand...
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
 
Thanks,
That's what I was thinking when I sent the e-mail.
Just wasn't sure.

Ron
 
Back
Top