Hi, I'm trying to build a dynamically filled drop down select box. However, I keep getting an error message which I cannot resolve, and I'd appreciate some advice. The error message is: "ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. SQL = "SELECT JokeTitle FROM Text" Data Source = "Jokes" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (3:14). " The code for the form is below. Please note that the name of the table is 'text'. <CFQUERY DATASOURCE="Jokes" NAME="Titles"> SELECT JokeTitle FROM Text </CFQUERY> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Jokes</title> </head> <body> <h1>JOKES</h1> <FORM ACTION="jokesaction.cfm" METHOD="POST"> Please select the joke titles from the contents of the select boxes below. You may select up to five titles at a time. Joke title #1: <SELECT NAME="JokeTitle"> <OPTION> <CFOUTPUT QUERY="Titles"> <OPTION VALUE="#JokeTitle#">#Titles# </cfoutput> </select> </FORM> </body> </html> Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop & maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.