Hi to all the Guru guy and girls here,

Ok.. I have a form which is composed of a form and a sub form and of course it feeds info to a table and a sub table. Now, I have a query that pulls the info that goes in these forms from a separate file. Is there a way to create a macro or a form that auto populate from the results of the query?

I guess that I need more of a macro that can read from the query "results" and key in the info on the form. I can't make an append query since the main table has an auto number field and when I do the append query the main table works fine but the sub table data does not link to its parent data on the main table. Do you guys have any suggestions?