Main form field

[Hazo69]

Main form Fields named Status, Date, Date Referred, Date Accepted, Date Declined, Date Property Accepted, Date Closed. The field named Status to be updated to either Referred, Accepted, Property Accepted or Closed
when the following fields have dates entered into them for example: if Date Referred>=Date ="Referred", & if Date Accepted field is >=Date Referred = "Accepted" & if Date Property Accepted>=Date Accepted="Property Accepted & if Date Closed>=Date Property Accepted="Closed"
Hopefully someone can tell me where to go

 

[GinaWhipp]

Put these in the After_Update event of the prospective fields...

[CODE] 
If [Date Referred]>=Date() Then
     Me.Status = "Referred"
Else
     Me.Status = ""
End if

If [Date Accepted] > = [Date Referred] Then
     Me.Status = "Accepted"
Else
     Me.Status = ""
End if

If [Date Property Accepted] >= [Date Accepted] Then
     Me.Status = "Property Accepted"
Else
     Me.Status = ""
End if

If [Date Closed] >= [Date Property Accepted] Then
     Me.Status = "Closed"
Else
     Me.Status = ""
End if

Let's be sure to confirm those control names as I was going off of what you posted.