Subform and One to One

  • Thread starter Thread starter David
  • Start date Start date
D

David

Greetings,

I am having a little problems with a subform(s) involved
in a one to one relationship with the parent form. The
problem is that I keep getting an error; "The field
mytblName.myLinkedFieldName cannot contain a Null etc."

I believe the error to be generated from the subform
because when tabbing from the parent form to the sub the
error does not appear. It only appears after filling in
data in the sub and advancing to a new record.

The table of the main/parent form actually does have all
the data in it, including the linked field data. Seems the
subform just isn't recieving the info.

I have a suspision that the problem is because the parent
and child have a one to one relationship. But this is only
a shot in the dark.

Anyone have any ideas?
 
Forgot one thing.

I do not just want to use a query to handle the one to one
part with no subform as I am hoping to be able to change
the SourceObject of my subControl.
 
Back
Top