Web Development

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.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums