Name? error in Access 97

I am running into a problem and have no idea how to fix
it. I have a form with a two subforms inside of it. When I
first oopen up the main form one of the fields in the
subform will have "the Name?" error. If i try going to a
different record the error will remain. The weird thing is
that if I open up the design view, and then go back to
form view, the error is gone and the information is now
loaded in the subform.

Is your subform based on a query? Is there a link between the main form and the subform? It sounds like the record source of the subform is not refreshed or you are just having a problem with that field (if all other fields are okay). Have you tried adding a new field?




----- wrote: -----

I am running into a problem and have no idea how to fix
it. I have a form with a two subforms inside of it. When I
first oopen up the main form one of the fields in the
subform will have "the Name?" error. If i try going to a
different record the error will remain. The weird thing is
that if I open up the design view, and then go back to
form view, the error is gone and the information is now
loaded in the subform.