On Mon, 6 Aug 2007 12:48:00 -0700, Ross Caldera <Ross
I have a form and subform together. I did change the key, but made sure one
to many relation was ok. I can not update my data. It like the keys are just
lock. Please help to solve this problem.
You changed "the key".
What key? How would you expect any of the volunteers here to know what you
changed, what you changed it from, and what you changed it to?
What is the Recordsource property of the mainform? Of the subform? Please post
the SQL. What are the Master and Child Link Fields?
Ross Caldera
619-<omitted>
or email <omitted>
Posting your private contact information in a public newsgroup, read by people
all over the world (volunteers, other question-askers, spammers, thieves, who
knows who all) is most imprudent. It's also considered impolite; this is a
volunteer, peer support newsgroup. Ask here... come here for the answers.
You might want to look at
www.mvps.org/access/netiquette.htm for a (somewhat
dated but still generally good) primer on newsgroup use.
John W. Vinson [MVP]
