I have a subform on my main form and here is the dilemma. The append query works fine except it creates a whole complete NEW record, not just an added record to the existing record. i.e. (subform record) Anyway around this? Both forms use the same table as the recordsource.