J
JimN
A form for new student’s demographics has a subform for selecting courses,
which has been used for 6 months on 6 computers in a Frontend-Backend network
configuration. In the last week, when a second field is started in the
subform or the subform has lost focus the error message, “keyfield cannot
contain a nullâ€, appears. The keyfield (SS#) in the form has data entered
and the link child fields and link master fields properties for the subform
are the SS#â€. How can the condition that causes the error message be removed?
A SS# textbox has been added to the subform and the textbox shows the
correct SS# data when the subform gets focus. Exiting the new student form
gets an error message that the record can not be saved. The table that is the
record source for the new students form shows the new student’s data just
entered, but the table data that is the record source for the course
selecting subform was not saved.
In the same database there is another form which retrieves existing students
for editing and the associated subform for selecting courses does not get the
error message when editing or adding data.
which has been used for 6 months on 6 computers in a Frontend-Backend network
configuration. In the last week, when a second field is started in the
subform or the subform has lost focus the error message, “keyfield cannot
contain a nullâ€, appears. The keyfield (SS#) in the form has data entered
and the link child fields and link master fields properties for the subform
are the SS#â€. How can the condition that causes the error message be removed?
A SS# textbox has been added to the subform and the textbox shows the
correct SS# data when the subform gets focus. Exiting the new student form
gets an error message that the record can not be saved. The table that is the
record source for the new students form shows the new student’s data just
entered, but the table data that is the record source for the course
selecting subform was not saved.
In the same database there is another form which retrieves existing students
for editing and the associated subform for selecting courses does not get the
error message when editing or adding data.