I have a form which is comprised of a main form, and three subforms. So far I have one of the subforms working great, with the relationship working.

I takled the second and am having a problem. When you enter the second subform, and enter any data, it will then not allow you to exit that subform to access any other portion of the form. Nor can you go into design view. It is as though I am locked into the subform. The second oddity is that when it reaches the last field in the subform, (the subform is in Continuous form mode, and a duplicate has appeared on the screen,) it will not allow me to enter into the next record on the subform.

Any help would be greatly appreciated.

Peter Paul

I just ran into this yesterday! The problem was caused because I had removed a column from a table and forgot to remove it from the subform. Access did not give me an error, it just wouldn't leave the subform. Changing a column name would have the same effect. Also, invalid link fields cause strange problems.

Pat, you are exactly right. I found one of the fields which was misnamed originally, then corrected, but the correction had not made its way all the way to the subform.

Thanks a bunch,
Peter Paul