N
niuginikiwi
Hi all,
I have searched the newsgroups but I can't find something that is within
what I am looking for.
I have a form with a subform based on a query.
There is a Yes/No field in that query that originates from the "ONE" side of
the one to many relationship.
I also have a combo box to store the PK of the ONE side table.
after I create a record on the subform by selecting a value from the ONE
side table and then filling in the rest and click on that Yes/No (a check
box) field, I get a error message poping up saying " Field can not be updated
Error 3164 ".
But if I click out of that particular new record and click back on that
Yes/No field, it works fine with no error message. But I don't want to get
user to remember to always click out of that new record and come back to
update that check box. What is wrong here. I can't figure it out. Can anyone
help me?
Thanks
I have searched the newsgroups but I can't find something that is within
what I am looking for.
I have a form with a subform based on a query.
There is a Yes/No field in that query that originates from the "ONE" side of
the one to many relationship.
I also have a combo box to store the PK of the ONE side table.
after I create a record on the subform by selecting a value from the ONE
side table and then filling in the rest and click on that Yes/No (a check
box) field, I get a error message poping up saying " Field can not be updated
Error 3164 ".
But if I click out of that particular new record and click back on that
Yes/No field, it works fine with no error message. But I don't want to get
user to remember to always click out of that new record and come back to
update that check box. What is wrong here. I can't figure it out. Can anyone
help me?
Thanks