Message Box Prompt

[CSmith]

I have a field named EMP_AMT_DED and I need for the amount entered into the text box to be 1250.00 and if the amount is anything less, I need a message box that prompts the user to explain why in the deduction history memo box. Once the user clicks OK on the prompt, I need to setfocus to the memo box. Simple but I can't think of it right off.

Thanks for any help...

[Michael R]

I have a field named EMP_AMT_DED and I need for the amount entered into the text box to be 1250.00 and if the amount is anything less, I need a message box that prompts the user to explain why in the deduction history memo box. Once the user clicks OK on the prompt, I need to setfocus to the memo box. Simple but I can't think of it right off.

Thanks for any help...

You can use the Validation Rule proprety that is in field's control propreties. Set it to
=1250.00
Use Validation Text proptery for message box pop-up explanation.

[CSmith]

You can use the Validation Rule proprety that is in field's control propreties. Set it to
=1250.00
Use Validation Text proptery for message box pop-up explanation.

I am not clear on how to do that. In the validation rule box, the expression builder opens. Can you give me specific steps on how to perform what you suggest I do.

[CSmith]

You can use the Validation Rule proprety that is in field's control propreties. Set it to
=1250.00
Use Validation Text proptery for message box pop-up explanation.

I think I have it Michael, thanks alot for the suggestion

[CSmith]

You can use the Validation Rule proprety that is in field's control propreties. Set it to
=1250.00
Use Validation Text proptery for message box pop-up explanation.

Ok, another problem, when the amount is entered and it is less than 1250.00 I want the field to keep whatever value is entered I just want an explain in the memo box. The way it is set up now, it won't allow the field to keep the entry.

[Michael R]

Ok, another problem, when the amount is entered and it is less than 1250.00 I want the field to keep whatever value is entered I just want an explain in the memo box. The way it is set up now, it won't allow the field to keep the entry.

Ah, I see. So you shoudn't use validation rule as its function is to block enteries that are not in a certain creteria.

Go to the textbox Propreties, to the Event tab. Go to After Update row. A "..." button will show up, click on it. A VBA window will open. Make sure the following code is there:

Private Sub yourtextboxname_AfterUpdate()
    If Me.yourtextboxname.Value = 1250 Then MsgBox "your message here"
End Sub

Close the VBA window and try out the form.

[NeoPa]

You'd also need to use the .SetFocus() method of the Memo control.