Hi there,
I have another problem about the escape identifier. There is a text box in my form. When I input any word without apostrophe('), it is fine to run the query and save the input in the table. On the contrary, I got a syntax error message when there is an apostrophe in the textbox. I think it is the escape identifier problem, since in VBA, the query is "Insert into filelist(subclassfication) values (textbox)". However, I don't know how to solve this problem? Does anyone know? Thanks in advance!
lgirl
I have another problem about the escape identifier. There is a text box in my form. When I input any word without apostrophe('), it is fine to run the query and save the input in the table. On the contrary, I got a syntax error message when there is an apostrophe in the textbox. I think it is the escape identifier problem, since in VBA, the query is "Insert into filelist(subclassfication) values (textbox)". However, I don't know how to solve this problem? Does anyone know? Thanks in advance!
lgirl
