How to ensure require field are enter

[wongray]

Hi Again,

I have a form that contain 2 sub-form and I would liike to know how to do a validation where the field require must have an entry?

The field that I need to are:
- Name
- Country
- Detail1

please open the frm_Main to see the sample

Apprecaite your advice..

wongray

 

[HiTechCoach]

I normally use a form's before update event to do data validation.

You may also want to set the field's required property in the table.

 

[The_Doc_Man]

When you create a new record on a form, it doesn't matter if a required field is null until you actually try to store it. Storing would occur based on an explicit "COMMIT" button or the RecordSelector button on the form (if you allow that to be seen) or an implied "Go To Next Record" or "Go To Prior Record" function based on the record navigator buttons.

Therefore, a simplistic approach would be to mark the table's fields REQUIRED = YES if you really mean they must not be absent. There is also the option for text boxes to allow or not allow zero-length strings. Look into those properties as a way to force your input to not be empty, null, zero, or blank.