Emmanuel
Master Tech
- Local time
- Today, 07:10
- Joined
- Sep 4, 2002
- Messages
- 88
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?
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?
