Validating mutiple entry in a subform

[Grooz13]

Ok I have a subform who contains multiple order and the user needs to push a button after entering those order to validate that the order is finished and ready to go in production... however I want them to put a delivery date absolutly.... They can enter the order for now and do other jobs and come back to this one once they know when they will received it so allowing null = No is not a solution for this problem... I did
If Me.Sf_Order!Reception_Date = Null



but it will only validate the first one of the Subform Datasheet...

Anyone have an idea ?

[NTC]

Since you allow them to leave that field empty; but then want to enforce that it is complete - - - your first decision is as to which event(s) the user is in when you want to harass them with reminders or freeze them totally.

The second decision is the best method to do that. That sort of depends. A few ideas; you easily can make a query to find all records with null in that field. Do a DCount of that; if yes (actually if count >0 )- pop them up in a new form with those records. Or just message to them that they have uncompleted records.

DCount is something you want to become acquainted with; look it up when in VB help, and if you have a VBA text book it will have it. Very helpful when needing to identity if records exist. As an advanced beginner you will be able to experiment with it and make it work.