vba - Access 2010 Afterupdate - set date on field -
i've got db need on please.
i've got tasks database - want set date completed when status combo box marked completed.
so combobox called "txtstatus"
i'd when set completed updates field in tasks table (called completeddate) populated current date.
i've tried doing afterupdate , if statement i'm getting nowhere. thoughts?
i sure have sorted this, in case else struggling:
private sub txtstatus_afterupdate() if me.txtstatus = true me.completeddate = date else me.completeddate = null end if end sub
Comments
Post a Comment