Microsoft Access

[Guest]

How do I keep boxes in my form locked until another box is updated. For
example, in my sales sheet, I don't want my customer service people to be
able to click "ALL DONE" until the credit card field has been updated.

 

[fredg]

How do I keep boxes in my form locked until another box is updated. For
example, in my sales sheet, I don't want my customer service people to be
able to click "ALL DONE" until the credit card field has been updated.

Set the [AllDone] control's enabled property to No.

Code the [CreditCard] AfterUpdate event (and also the form's Current
event):
[AllDone].Enabled = Not IsNull([CreditCard])