create a table code

[Jeff G]

I would like to programically create a table just before
opening a form and populate the table with an existing,
non updatable recordset. When the form is open, it will
contain information from the created table which will then
be updatable. Any suggestions on code to use for this?

Thanks
Jeff G

 

[Tim Ferguson]

I would like to programically create a table just before
opening a form and populate the table with an existing,
non updatable recordset.

Get the SQL for the existing nonupdateable recordset and turn it into a
INSERT INTO YourNewTable
SELECT etc etc

command, then execute it. This is an append query into the new temp table.

When the form is open, it will
contain information from the created table which will then
be updatable.

I do not understand how this will help you though. In most cases, a
recordset is nonupdateable because it is not possible to know which record
belongs to a particular row in the recordset, so you may not be able to
store any changes that the user makes anyway.

Hope that helps


Tim F