OnNotInList Event Combo Box

[jgncoh]

I am trying to edit a database that I did not create. The original creator did not follow good naming convention and left spaces in the names of the tables
(ex., Lookup: Resources instead of tblResources).

This is causing me grief when I am trying to add VB for the OnNotInList Event for a combo box. I am trying to write a SQL statement to update the table if the user chooses to add a name not available in the combo box with the following statement:

"INSERT INTO Lookup: Resources ([Resource Name])

I do not think it likes the spaces in the table name. Any ideas. Thanks in advance.

 

[RoyVidar]

Try with [brackets] around spaces and special characters:

[tt]"INSERT INTO [Lookup: Resources] ([Resource Name]) values ('" & _
me!txtControlVithResourceName.value & "'") [/tt]

Roy-Vidar

 

[jgncoh]

That worked. Thanks!!