I appreciate your answering me so quickly. I must be
doing something wrong because the formula will not even
stay in the Update cell of the properties of the date
field. This is what I did.
I opened the form in design view. Went into the
properties of the [IA-Date] field, to the Update cell and
expression builder. I typed the following:
If Not IsNull ([IA-Sign])then If IsNull ([IA-Date]) then
[IA-Date] = Date()
Where [IA-Sign] is the signature field and [IA-Date] is
the date field. Can you tell what I did wrong?? The
formula would not stay in the Update cell. When I closed
the properties box and reopened it, the formula was gone.
This did not work.
the AfterUpdate>-----Original Message-----
>Assuming the data is being entered via a form, then usefield. The code you need>event of the control that is bound to the signaturenot be overwritten>is:
>If Not IsNull(Me.NameOfSigControl) Then
> If IsNull(Me.NameOfDateControl) Then
> Me.NameOfDateControl = Date()
> End if
>(The second If statement means that an existing date willor may not be what>if the entry in the signature field is updated. This mayand>you want to happen).
>"Aurora" <asonkaydon.com> wrote in message
>news:8c9501c3457e$46f62c40$a401280aphx.gbl...>> I am using Access 2000
>> In a form I have a signature field [IA-Sign](text field)
>> and a date field [IA-Date](date field). I want todays
>> date to come up automatically in the IA-Date field ifSign]>> when someone enters their name in the signature [IA-Rule I>> field.
>> In the date properties of IA-Date, under Validation>>> put
>> =IIf([IA-Sign] Is Not Null,[Date()]," "). But this
>> does not work. Does anyone have any ideas as to how to
>> make todays date come up only when someone has completed
>> the signature field (IA-Sign)????