Query

P

Pass-the-reality

I have a form that contains two fields [Status] and [Completion]. [Status]
is a drop down field. If I select "Complete" or CompleteDeem", I want
[Completion] to auto populate with todays date. Is there anyway I can put
something in the Expression Builder for the default value? What are my
options?
 
M

Maurice

In the afterupdate of the combobox place the following code:

if me.status="Complete" or me.status = "CompleteDeem" then
me.completion=date()
end if

this assumes you have the combobox set to one field. In case of two fields
you have to check the value you've assigned to the status Complete or
CompleteDeem (which is probably 1 or 2 in case of autonumbering)

hth
 
Top