Automatically populate a date field

[Mark Drayton]

Hello!

I've searched on previous date questions but to no avail - so here goes...

I'm creating a issue/question logging Db with "Issue raised by" & "Issue Answered by" fields. I have set up a Combo Box on the "Issue Answered by" field listing names of people.

When a name is selected I would like the "Answered Date" field to be populated with the current date automatically.

My knowledge of Access is basic, so please be kind

Many Thanks

Mark

Access 97

 

[Kodo]

on the combo box's afterupdate event put this.

Me.AnsweredDate=Date()


the format is Me.[FormFieldName] where FormFieldName is what you named your answered date form field.

 

[Mark Drayton]

Thanks Kodo - it worked a treat!

Many Thanks

Mark