| | |
|
|
|
No Not In List |
|---|
| message from Frank on 4 Jun 2004 |
I have a combo box that has a list of employees names. I
want to be able to update it without actually having to go
to the table and edit from there. I was told to go to
the On Not in List event under properties, but I am
stuck there. I searched the net for something pertaining
to this, but nothing was produced. Can someone help me
out with some code perhaps or a macro that might work here.
Thanks,
Frank
|
| =?Utf-8?B?VGFzaGE=?= replied to Frank on 4 Jun 2004 |
If you want other people who use your db to be able to do this as well just set the limit to list property to no. This should add the value to the table. (Please correct me if I am wrong). If you just want you to be able to do it, set up a button to open a data entry form. Enter your data there to add to the table. However you will have to either close your original form with the combo box and reopen it or requery your combo box. You can do this in the on close event of your data entry form.
|
| Doug Munich replied to Frank on 5 Jun 2004 |
If you put this under the not in list event for the combo box it should add
the value to the list (and set it to that value).
Private Sub Combo2_NotInList(NewData As String, Response As Integer)
MsgBox "That value is not in the list. I will add it.", vbOKOnly
Combo2.AddItem (Combo2.Text)
Combo2.Value = Combo2.Text
Response = True
End Sub
"Frank" <anonymous@discussions.microsoft.com> wrote in message
news:1848b01c44a3b$a84d7170$a101280a@phx.gbl...
|
|
Archived message: No Not In List (Microsoft Access Error Message)
