need a bit of code figured out

[wcrc]

This code doesn't work! That shouldn't suprise you supercoders, but I don't know how else to write this statement.

Any help?

Code:

Private Sub Equipment_Status_AfterUpdate()
If Equipment_Status = "AWP" Then
Me!subJob_Desc.Parts_Date.Required = True
End If
End Sub

Effectively, I would like to get the subform's Parts_Date field to be required if the equipment goes into AWP (Awaiting Parts) status.

Thanks

 

[WayneRyan]

wcrc,

Try:

Private Sub Equipment_Status_AfterUpdate() 
If Equipment_Status = "AWP" Then 
   Forms![YourMainForm]![subJob_Desc]!Parts_Date.Required = True 
End If 
End Sub

hth,
Wayne

 

[wcrc]

Sorry so long on the reply, but I realized after your post that I was trying to effect a table property (Required) in a form field. Once I changed the target to the table, it worked.

Thanks for the help.