Mandatory Fields on a Form

[gregor_davies]

How do I make all fields on a form mandatory, these fields are not necessarilly mandatory in the table but required if you are filling in the form.

Greg

 

[spacepro]

Welcome to the forum!

There are several ways,

Use the validation rule on each field or alternatively put code on the beforeupdate/insert events something like:

If IsNull(me.text1) then
'do something here
End if

I would use validation though, use the search function of the forum and you will find loads of posts that relate to validation rules.

Andy