E
Eddie Allen
I have a form that I am using a query based off of the clients names. I
have the following code to give the dialog message that a client must be
entered on the On Exit.
Private Sub Form_Close()
If IsNull(Me.[Client]) Or (Me.[Client] = 0) Then
MsgBox "You must enter a Client"
Exit Sub
End If
End Sub
what command do I use to stop the the form from closing?
Also have another simple question I hope. The combo box I have in my form
once picked has the list of clients in which you can chose. However the
user has the ability to manally enter a name which makes it not show up in
the querty since it is based off a set of clients in the list. What can I do
other than a list box that would stop users from being able to type in
clients?
Thanks for the help
Eddie
have the following code to give the dialog message that a client must be
entered on the On Exit.
Private Sub Form_Close()
If IsNull(Me.[Client]) Or (Me.[Client] = 0) Then
MsgBox "You must enter a Client"
Exit Sub
End If
End Sub
what command do I use to stop the the form from closing?
Also have another simple question I hope. The combo box I have in my form
once picked has the list of clients in which you can chose. However the
user has the ability to manally enter a name which makes it not show up in
the querty since it is based off a set of clients in the list. What can I do
other than a list box that would stop users from being able to type in
clients?
Thanks for the help
Eddie