I would not bother to create a querydef. You are building the SQL dynamically, so you could use the Currentdb.Execute method. It is faster, anyway. Add the terminating semicolon to this line: sql = sql + ", '" + ![Address 1] + "' ); " Then Currentdb.Execute sql, dbFailOnError But, I would also use a name other the sql as it is an Access reserved word. I typically

Is there something in your reply I missed? What I got back was just what I posted. -- Dave Hargis, Microsoft Access MVP "albert.repasky@bnymellon.com" wrote: On Jul 10, 2:51 pm, Klatuu <Kla...@discussions.microsoft.com> wrote: I believe your main problem is with understanding primary keys. Very seldom does a table need more than one field for a primary key. A primary key

I believe your main problem is with understanding primary keys. Very seldom does a table need more than one field for a primary key. A primary key defines a record as a unique entity. For example, your example of a City table with fldLocationID and fldCityID as the primary key is very suspicious. A City is a city regardless of location. The location may give you information about the city