View Full Version : Getting Names of field left null on Form


aqif
08-21-2001, 06:25 PM
Hi http://www.access-programmers.co.uk/ubb/smile.gif

Is it possible that OnCurrent Event of the form or Onclick event of any button I could get the names of the fields which are left null on the form. I have a tab form and want that user can get the information that he/she has left these fields empty for this record.

Cheers!
Aqif

Pat Hartman
08-21-2001, 07:56 PM
The proper place to do this is in the BeforeUpdate event of the FORM. You would test each relevant field for null. If any are null, you would display an appropriate message and most important - cancel the update. This will prevent any record from being saved if it is incomplete.