F Frank Dulk Feb 2, 2005 #1 How do for what do in the event when opening of the main form I, do verify if a field exists <> null in the subform?
How do for what do in the event when opening of the main form I, do verify if a field exists <> null in the subform?
M Michel Walsh Feb 2, 2005 #2 Hi, If DCount("fieldName", "TableName", strCriteria) = 0 Then ... there is no record in the table that satisfies the criteria with a not NULL value under the supplied field name. else ... end If Hoping it may help, Vanderghast, Access MVP
Hi, If DCount("fieldName", "TableName", strCriteria) = 0 Then ... there is no record in the table that satisfies the criteria with a not NULL value under the supplied field name. else ... end If Hoping it may help, Vanderghast, Access MVP
