"You cant assign a value to this object"

[desibasha]

"You cant assign a value to this object"

I keep getting this error when trying to add a record in my subform.

I beleive it's due to the relationships.

It's one to many and it needs to be one to many but the otherway around. Meaning the one that's right now set up as one need to be many and vise versa.

So, how can i change the relationship?
It's reversed.


Thanks!

I think that's the solution...but i may be wrong.

Any help would be greatly appreciated.

 

[desibasha]

if its not the relationship..what else could be causing this error to occur?

b/c its still not fixed

it wont let me add any new records to the subform.

 

[The_Doc_Man]

Can you be more specific here?

What physical action do you perform that triggers this message?

Is it the attempt to click the record control button? An attempt to move to the next record of the subform?

When I see this message, it tells me that some object in the form (or in your case, subform) does not have .value as one of its properties but you are trying to do something with it anyway.

For instance, the buttons of a control group don't have a .value property. Only the containing control group (the higher-level structure) has a .value property. I'm not saying that your problem is a control group/control buttons case - but rather that it is analogous.

Another problem that could cause this would be if something is unbound in some way so that you have no place to store it, or if the underlying object is part of a joined table and you don't have write access to that table that is part of the join. (Though in the latter case I would have expected a different message than you reported.)