Couple of quick questions

  • Thread starter Thread starter Eddie Allen
  • Start date Start date
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
 
Figured out the list box issue. Is it possble to customize the not in list
error message?
 
Back
Top