Changing Action on a Command Button

[ETCallHome]

Hi Guys/Gals,

I need your expertise here... I created a command button to open a form. I also built validation code to check that all required fields have been entered. If all the fields are entered, then the command button action to open the form is actioned. However, if all the required fields are not entered, I want the command button action not to execute. Here is my questions...

1. How do I stop the command button from opening the form is all the required data is not entered?
2. In which event procedure due I enter the code?

Your assistance is highly appreciated.

Thanks

[RuralGuy]

Where have you put the validation code?

[ETCallHome]

Hi Allan,

I actually resolved this issue by disabling the command buttons when the form is loaded... Me.FormName.Enable = False, and only when all the required fields have been entered do I enable the command buttons... Me.FormName.Enable = True. However, I have different problem now... as follows:

1. On the Lost Focus event, I validate whether the field is null, if it is.. I setup a msgbox prompting the user to enter the required field and set the focus back to the field.
2. The validation is working and the msgbox is displayed successfully, but it sets the focus to the next field according to the Tab Index... not sure why it doing this... see code below:

Private Sub Field_LostFocus()
If IsNull(Me.Field) Then
MsgBox "Please enter field as it is required"
Me.Field.SetFocus
End If
End Sub

[RuralGuy]

You need to use the Exit event rather than the LostFocus event and then simply use Cancel = True to keep the focus in the current control. Don't forget to use the Thread Tools and mark this thread as Solved when appropriate.

[ETCallHome]

Thanks Allan... I put it on Exit Event and it work fine...

[RuralGuy]

Glad we could help.