Disable Command button if a field is not filled

  • Thread starter Thread starter JohnZ
  • Start date Start date
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!
 
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
 
Back
Top