populate a field with 'yes' after you enter a date in another field

[nhonelove]

I can't remember how to populate one field when another field has been updated/populated.

Any help would be greatly appreiciated.
Thanks

[jimatqsi]

Put code in the AfterUpdate event of the date field. Something like
me!field2="Yes"

[nhonelove]

Thanks that worked. Now if they decided to delete the info (date) in the other field - how can I return the updated field to 'No'. I think I would need to run some kind of query I guess, but how do you build that into an event?

[jimatqsi]

No, you would use the very same method, but you put a 'No' instead of 'Yes'. Something like

If isdate(me!Datefieldname) then
me!field2="Yes"
else
me!field2="No"
endif
 

[Rabbit]

Can I point out there's no need to store a yes/no to show whether or not a date field has a value? You can see that without an additional field. And if needed, it can be calculated on the spot.

[NeoPa]

As Jim says, you'd need an AfterUpdate event procedure similar to :

Private Sub Another_Field_AfterUpdate()
    Me.[One Field] = {NewValue}
End Sub