Can't add a record because because a record is required in the sub

  • Thread starter Thread starter Jo Gjessing
  • Start date Start date
J

Jo Gjessing

Hi Folks,

In a database of mine I have a form with a few text boxes (first name, last
name ...) and some subforms for additional information. The problem is: When
I try and register a new person and have typed in what is required in the
form, I move to the first subform. Then Access says that it can't add a new
record (in the form, as I understand it) because a record is required in the
subform. Have you any idea what this is and how I fix it? If you have please
let me know. Thank you very much in advance.

Jo
 
That is very unusual. Are you sure that the message is not that Access
cannot add a RECORD to the person table because a RECORD is required in the
table useb by the subform?

I would suspect that your relationships are causing the problem.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Check the Link Master and Link Child properties in the subform control.
The Link Master property should be set to the field(s) in the Mainform's
record source the relate to the the record source of the subform. The Link
Child Field property should contain the name of the fields in the subform's
record source that relate to the record source of the main form.
 
Back
Top