Creating a pop-up based on what is entered in two fields.

[Danielle Cole]

Does anyone know who to make a pop up appear when in one field, Manual Refund or Manual Collection is chosen and two fields down, NO is chosen. I want the pop up to say "If Manual Collection or Manual Refund is chosen and ACH no, then no funds will be transferred to/from client without a loose form."

Thanks!

[malcolmk]

Try using the on exit event of the ach field to test values for ach and refund fields, open form accordingly.

[Danielle Cole]

There are other options allowed under the adjustment type. How do I make it so that if only Manual Refund or Manual Collection are chosen along with ACH Needed selected as no, it will create the pop-up. The On Exit even will work, if ACH no, but I want the pop up to appear only when MRF or MCL

[slenish]

If i was you i would probably use an if statement to check the two text fields for the situation. You would also have to make a custom pop up form to open when the situation is true. I would put it in the before update event of the second text box (or ACH box) you are trying to compare to the first one.

You could do something like this,

ACH TextBox BeforeUpdate Event
 
Dim MText (0 To 1) as string
Dim ACHText as string
 
MText(0) = "Manual Refund"
MText(1) = "Manual Collection"
ACHText = "No"
 
If TextBox1 = MText(0) Or MText(1) And TextBox2 = ACHText then
   Popup = True
   Cancel = True
Else
 Cancel = False
End if