field exists <> null in the subform?

F

Frank Dulk

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

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
 
Top