Recent content by enohs

  1. E

    Auto populate a Check Box.

    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.
  2. E

    Auto populate a Check Box.

    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...
  3. E

    Auto populate a Check Box.

    No good. I tried changing =Format(Now, to =Format([Today], but still nothing. :confused: I am baffled.
  4. E

    Auto populate a Check Box.

    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...
  5. E

    Auto populate a Check Box.

    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...
Back
Top Bottom