Data Validation inContinuous Forms

[lina2401]

Hi all.
I really need help with this!
I have a continuous form displaying Name, DOB and ID and I have a control button that when I click on will store the above values on another table. My problem is that I need to validate the data entered and make sure that all fields are filled! I tried using the following
If Me.Name="" or Isnull(Me.Name) then
Msgbox "Enter Name"
Else
Msgbox "Name is OK"
End if
But it only works with the first row in the continuous form!! Is there a way in which I can accomplish the above?? Please HELP.

 

[RuralGuy]

You may want to revise the design a bit. Describe the business process you are implementing. Why do you need to move the records to another table?