Nulls in parent/child form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a unique record with a value of null for Mainform in fiield Date1.

Subform1 is linked in parent/child relationship, is linked field
SubformDate, and has multiple records with null values.

Parent/child linking works when a non-null record is diplayed in the parent
form, but does not work when the null record is diplayed.

Ideas????
 
MSROOKIE said:
Have a unique record with a value of null for Mainform in fiield Date1.

Subform1 is linked in parent/child relationship, is linked field
SubformDate, and has multiple records with null values.

Parent/child linking works when a non-null record is diplayed in the parent
form, but does not work when the null record is diplayed.
Click to expand...

In the underlying query for both forms use an Nz(FieldName) instead of the field
name itself. This is required because Null is not equal to anything (not even
another Null) and equality is what the MasterLink ChildLink properties work on.
 
Probably not a good idea to have a relationship based on null. There
is no true relationship between truly null data.
 
Back
Top