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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inactivate a subform 2
combo: multiple columns with a value list 1
Combo Box Yes/No error 2
Clear all fields in a form 3
Turning Data into a Table 1
Make a Date Field Autopopulate 6
Make field invisible/inactive depending on combo box in Datasheet 0
Turning a 3 column flat file into a "3D" Table 2

Back
Top