How to create a subform by querying table created at runtime
Posted on 2008-10-08
What I'm trying to accomplish is should be really simple (I think...). Create a subform, in datasheet view, that is populated by certain fields from a temporary table created at runtime. And subsequently, save these fields to a permanent table.
*****This database I am creating is an enterprise multi-user application (currently) with 78 tables, 82 queries, 52 forms, 345 procedures, 50 relationships, 14 reports and countless objects... I am the sole developer, not part of a team or project where there is someone I can consult with, no developer tools and I am not an expert by any stretch of the imagination. I just work really hard... *****
When the user uploads data from a spreadsheet, I create temporary tables from the tabs and ranges that contain the data needed. It is in this event procedure that I am trying to populate the subform.
My original design was not good, and the requirements have changed for the location of the subform (a different form). The original subform had it's sourceobject as a form, and the recordsource of that form was a temporary table created by a persistent query that was run after the temporary tables were created.... does not work.
I have researched this, and tried so many different methods I can not see straight....
My question is, how should a subform be developed so it can be populated with data from a temporary table and it's fields be accessible through a recordset or recordsetclone to save to a permanent table?
Thanks in advance....