Disable a field entry dependent on another field entry

[asinha9]

I have a form based on a query
In this I have a field [Expr_day] which calculates difference between 2 dates in days
I want certain fields on my form for e.g. [txt_amylase_300_d1] to be active only when its day 1 in the field [Expr_day]
I tried using the following code on 'after update' in the field [Expr_day]

If Len(Me.[Expr_day]=1 Then

Me.[txt_amylase_300_d1].Enabled = True
Me.[txt_amylase_300_d1].Locked = False
Else
Me.[txt_amylase_300_d1].Enabled = False
Me.[txt_amylase_300_d1].Locked = True


End If


But it just locks the field for all values

[June7]

It is not necessary to set both Enabled and Locked properties, Enabled is adequate. However, this won't work if form is in Continuous or Datasheet view. Use Conditional Formatting to enable/disable control based on criteria. Conditional Formatting is located on the ribbon Format tab.