To all who are interested and have given their input, I have uploaded a version of the database in the reply above if you wish to engage your skills.
Cheers all.
Thanks vbaInet, I have created a test Db with the fields on it. I can't send the orriginal due to Data Protection. I have set the [Enddate] as a user input and the [Today] as auto populate.
I really appreciate the time youo are putting into this. I was told that the forum users are...
Cheers for that, but it did not work. It returns the following error.
The object doesn't contain the automation objects 'Date.'.
I have changed the expression to the following but still no joy.
IIF(CDate([EndDate]) = Today, Expire.value = 1, Expire.value = 0)
I am in the dark and at the...
Hi All, I am new to this forum nut am assured that my queries will be satisfied.
Here we go.
I have a form with an [Enddate] field, a [Today] field and a Check box.
The [Today] field has a control source of =Format(Date(),"dd mmm yyyy") to display the system date eveytime the form is opened...