Create and destroy a Recordset

[KPR]

I know this is simple but I'm new to Recordsets and can't find the code.
I would like to create a temporary table when my form loads, it should
contain 3 numeric fields and 3 Yes/No fields. I need to write temporary
values to these fields when this form is open and then destroy the table when
the form is closed. I'm using a permanent table right now but soon the
program be in a multi-user environment.

Thanks,
Ken

 

[Jeff Boyce]

Ken

I'm not there, so I can't be sure, but it sounds like another approach would
be to keep your table and add a User field. That way, the table could
handle multiple users.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tom Wimpernark]

you don't need to create a temp table

you can do all of tihs on a real table

 

[George Hepworth]

Aaron Kem.pf has begun posting under a new alias.

 

[KPR]

Thanks Jeff, can I do this without having a user logging in?