i have a field name with a space in it. With the code im using how can i stop it brining up the error.

expected: list seperator or )

the fieldname is CFirst Name

[CFirst Name]

This should help you to understand why all the Access experts say to use no spaces or special characters in your names.