Frames and check if it is selected

[esengul]

I have a form that has 5 frames with option boxes. before updating my table, i want to see if they select all frames or not. if they didn't, i want to show a warning msgbox with the frame name that they didn't select.
Thanks in advance

 

[THWatson]

esengul
You could put code on the BeforeUpdate event for the form.

If IsNull([Frame1]) Or IsNull([Frame2]) Or IsNull([Frame3]) Or IsNull([Frame4]) Or IsNull([Frame5]) Then
MsgBox "Oops"
Cancel = True
Exit Sub
End If

Of course, change the names to your own frames, and the message to whatever you want it to be.

Or if you are updating from a Command button, include that at the start of your code.

Tom

 

[esengul]

Thank you
I got it.