Force an Entry

[Syerston]

I would like to be able to force a user to choose an option on a frame before they are able to continue. At the moment when a value is input to a text box, a message box appears advising the user to choose odd male or female. However, the form will allow the user to continue without inputing a value.

The perfect scenario would be after update on the text box the message box would appear, on OK, focus would be set on the appropriate frame. If the user then tries to move on without a value being input the message box will appear again etc.

 

[tomschafer]

I'm assuming that the male/female input is what is in the frame that you want to force to be inputted. Try this...

Private Sub [FrameName]_Exit(Cancel As Integer)

If [FrameName] = "" Then
MsgBox "[Enter Your Message Here]"
Cancel = -1
End If

End Sub