Unanswered: Adding an item using limited list in VBA
I am trying to add a new item (City) using a Combo Box in a Customers form. The Form is in Access 2002 and tables are MS SQL Server 2000.
I would like to use a code like one I used when working with Access 2002 tables but without success. If a new City is typed the code asks if
new city will be added. Can someone suggest a version which would work on a MS SQL Server 2000?
Here is the VBA code I use when working against Access 2002 tables.
Dim Response As Integer
Private Sub City_NotInList(NewData As String, Response As Integer)
' Add new City
On Error GoTo City_NotInList_Err
Dim conConnection As ADODB.Connection
Dim StrSQL As String
Dim iAffected As Integer