How to specify the reason when choose combo box to inactive.

[a.phoenix]

Hello, everyone



I have the combo box status: active and inactive, and field for reason the problem I have that when user select inactive, they do not give the reason this customer is inactive.


Can I use macros or Modules to command when select inactive they need to type the reason if not do it they will see the warning message and can't pass this field.


Think you very much for your help.
Prakan Pongpanpath

[Welshgasman]

Yes, just check the combo and the reason field and issue the required message.
I would use the Before_Update event of the form, cancel the update and set focus to the reason field.

You could have also code in a control event, but no guarantee that the user will enter that control.

[a.phoenix]

Thanks for your answer, but in my combo box I have active and inactive. I need the reason only when user select "inactive" and I don't know how to write the modules or set macros

please tell me more...

Thank you.

[Gicu]

In the BeforeUpdate of the form you need to enter your validation:

If Me.cboYourCombo="Inactive" AND IsNull(Me.txtReason) Then
     Msgbox"You must enter a reason"
     Me.txtReason.SetFocus
     Cancel=True 'stop the update
End If

Give it a try and post back if you get stuck!

Cheers,

[a.phoenix]

Think you very much for your answer I will try it