automatically add information after date exceeds?

[stu_c]

Hi all

I have a field "Permit_Date_Expired" field automatically is created by adding one year to the "Permit_Date_Issued" field.

when the "Permit_Date_Expired" field exceeds TODAYS() date I want it to automatically change the field "Permit_Holder" to say Expired is this possible?

 

[pr2-eugin]

Thanks for posting it in a separate thread.. So this is a Query right? So in the Permit_Holder field.. use an IIF condition.. something like..

Permit_Holder: IIF([Permit_Date_Expired]>=Date(),"Expired","Active")

Post back if still confused.. Or if I have got it wrong, could you give another shot in explaining your problem?

 

[bob fitz]

If you have the field "Permit Date issue" in your table you do not need or want "Permit holder" or "Permit Date Expiry" in the table because these are calculations that should be done as and when required. IMHO Keeping these fields will compromise data integrity and make development of your application more difficult than it need be.

 

[stu_c]

no its done in a form all

all i need when "Permit_expire_date" exceeds "TODAYS" date it automatically puts EXPIRED in "Permit_Holder" field

 

[pr2-eugin]

In the Form's Current property, do the check..

Private Sub Form_Current()
If Me.Permit_expire_date >Date() Then
    Me.Permit_Holder = "Expired"
End If
End Sub

 

[bob fitz]

no its done in a form all

And is this form bound to a table?

all i need when "Permit_expire_date" exceeds "TODAYS" date it automatically puts EXPIRED in "Permit_Holder" field

First, Tables gave Fields. Forms don't have fields. Forms have Controls which may or may not be bound to Fields.
Are "Permit_expire_date" and "Permit_Holder" both controls that are bound to fields in the forms table?

If so, please read post #3 again.