Enable or Disable Fileds after update

[DavidAC]

Hi, i am trying to update a field to be enable if a certain condition is met in another field. However i keep getting syntax errors any help would be appreciated. the field that contains the condition is a yes/no field and here is the code i am using.
If Me!Is will update = '-1' Then
Me!previous_document_id.Enabled = True
Me!Date_previous_destroyed.Enabled = True

Else
Me!previous_document_id.Enabled = False
Me!Date_previous_destroyed.Enabled = False

End If

Regards

David

 

[bat17]

If "Is will update" is the name of your Yes/No field then you need to enclose it in Square Brackets.
If Me![Is will update] = True Then
Access does not like spaces in names in code.

HTH

Peter