Access 2000 Tough Question!

I have a Database with Members and Dependents. Each Member can have 0, 1,2,3,or more dependents.

I created a dependent form and I want to make sure that EVERY Dependent has an address entered.

I wrote if isnull (Address) then
Msgbox “NO Address entered:
end if

but this code only works for the dependent you are viewing. Before closing the form, I want to check if ALL DEPENDENTS have an address enterred.

And ideas or solutions would be greatly appreciated!

Alan (New York City)