Is Variable a table name? set UC.AddUserClassSubmit = (the select must be in parenthesis)
as strText ( is unnecessary) & "'" ) ; " ( at end a mismatch in number of quotes) --- In [email protected], Lyanne Rheeza Ong <[EMAIL PROTECTED]> wrote: > > Hello, > > Please help on my query.. compile error expected end of statement error. > > strSQL = "UPDATE UsersandUserClasses SET UsersandUserClasses.AddUserClassSubmit = SELECT 'AddUserClass' + Variable.ApplicationUserClassName + Variable.ParentApplicationUserClassName as strText " _ > & "FROM Variable WHERE Variable.ApplicationUserClassName = '" & Me.cboApplicationName.value & "'" ) ; " > > > Debug.Print strSQL > CurrentDb.Execute strSQL, dbFailOnError > > thanks, > lyanne > > > > L y a n n e R h e e z a C. O n g > > > > > > > --------------------------------- > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. > > [Non-text portions of this message have been removed] >
