Disable Command button if a field is not filled

J

JohnZ

Hi, I was wondering if someone could tell me how to disable my
Store/Save/Next button if all my the fields on my form have not been
filled in.

Thanks!
 
J

Jeff Boyce

John

One approach would be to write a procedure that checks to see if all the
controls have values and, if so, enables the command button (you'd start off
with it disabled). Then, behind each control, call the procedure from the
control's AfterUpdate event (i.e., after the control is updated, check all
controls and enable the <Save> button if all are "filled").

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top