Discussion Locked
Access 2000 Tough Question!
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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)