Hi,
I'm not sure if I can explain this properly or if it can be done but I'll give it a go.
I have a combo box with a list based on a Query. I also want the user to add new names if they so wish but if they do so, I want a message box to pop up asking if they wish to add this name to the list (yes/no).
I have writen code for the NotInList event. Is this correct? If so, please help me with my existing code below:
Private Sub Bid_Manager_NotInList(NewData As String, Response As Integer)
Dim strMessage As String
Dim ctl As Control
strMessage = "Do you wish to add '" & NewData & _
"' to the list?"
If Confirm(strMessage) Then
??????????
Else
DoCmd.CancelEvent
End If
Thanks
Keza
I'm not sure if I can explain this properly or if it can be done but I'll give it a go.
I have a combo box with a list based on a Query. I also want the user to add new names if they so wish but if they do so, I want a message box to pop up asking if they wish to add this name to the list (yes/no).
I have writen code for the NotInList event. Is this correct? If so, please help me with my existing code below:
Private Sub Bid_Manager_NotInList(NewData As String, Response As Integer)
Dim strMessage As String
Dim ctl As Control
strMessage = "Do you wish to add '" & NewData & _
"' to the list?"
If Confirm(strMessage) Then
??????????
Else
DoCmd.CancelEvent
End If
Thanks
Keza