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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
In the status field's AfterUpdate event, check what its value is. If it's
inactive, set the Date of Termination field to visible.
 
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
 
Back
Top