I have a form called "Breeding" with subform called "Youngsters". I would like to append all records from "youngsters" to a table called "Pigeons". I created a select query, selected all the required fields and then changed it to append query with the following criteria under the "YoungsterID" field (which is also the primary key) [Forms]![Breeding]![Youngsters]![YoungsterID]. (I read this in a previously posted thread) But it doesn't work! :-( It only give me a screen almost like a parameter query where i have to put in the YoungsterID that should be appended to the new table. Can anyone please help me out here? Regards