on the database tab, expand the connection, then expand the tables and expand the table used in the recordset, send a screen shoot of database tab showing the tables and the columns in the table used in the query, also send a screen shot of the show region issue you mentioned before.