General discussion


Access 2000 Tough Question!

By MRA2 ·
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)

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums