How to: Make a field appear when combo option is chosen...

[Access rookie]

Hello,
I have an employee status field that offers two choices: Active and
inactive. When the entry person chooses 'inactive,' I would like my Date of
Termination field to appear. I know it has something to do with an event, but
I'm not sure how to do it!

Thanks,

John.

 

[Douglas J. Steele]

In the status field's AfterUpdate event, check what its value is. If it's
inactive, set the Date of Termination field to visible.

 

[Rick B]

In the 'On change' event for the status field, put an event procedure
like...



Private Sub Status_Change()
TerminationDate=Date()
End Sub



Hope that helps,

Rick B