How do you write records from a temporary table to a permanent table.
I have a one to many form where I am trying to have the user select which
task code they want for a given task. These are in a subform. The subform has
63 DSR codes that will display on the screen. The user has 5 check boxes to
select task code for each of these 63 codes. He can only select 1 from the 5.
I would then like to take the populated check box and write it to a permanent
table.

On Sep 22, 1:59*pm, Michelle <Miche...@discussions.microsoft.com>
wrote:
> How do you write records from a temporary table to a permanent table.
> I have a one to many form where I am trying to have the user select which
> task code they want for a given task. These are in a subform. The subformhas
> 63 DSR codes that will display on the screen. The user has 5 check boxes to
> select task code for each of these 63 codes. He can only select 1 from the 5.
> I would then like to take the populated check box and write it to a permanent
> table.

use an append query that uses the checkboxes to filter the data.
then create a delete query to delete those records from the original
temp table once completed.

Thank you. I will give that a try.
Is it better to use Access queries or write VBA code creating recordsets
etc. to do the same thing. What will give you the greatest efficiency?

"(E-Mail Removed)" wrote:

> On Sep 22, 1:59 pm, Michelle <Miche...@discussions.microsoft.com>
> wrote:
> > How do you write records from a temporary table to a permanent table.
> > I have a one to many form where I am trying to have the user select which
> > task code they want for a given task. These are in a subform. The subform has
> > 63 DSR codes that will display on the screen. The user has 5 check boxes to
> > select task code for each of these 63 codes. He can only select 1 from the 5.
> > I would then like to take the populated check box and write it to a permanent
> > table.
>
> use an append query that uses the checkboxes to filter the data.
> then create a delete query to delete those records from the original
> temp table once completed.
>

Using a query is almost always significantly more efficient than using VBA
to perform the same function.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Michelle" <(E-Mail Removed)> wrote in message
newsE721915-1931-43B0-B574-(E-Mail Removed)...
> Thank you. I will give that a try.
> Is it better to use Access queries or write VBA code creating recordsets
> etc. to do the same thing. What will give you the greatest efficiency?
>
> "(E-Mail Removed)" wrote:
>
>> On Sep 22, 1:59 pm, Michelle <Miche...@discussions.microsoft.com>
>> wrote:
>> > How do you write records from a temporary table to a permanent table.
>> > I have a one to many form where I am trying to have the user select
>> > which
>> > task code they want for a given task. These are in a subform. The
>> > subform has
>> > 63 DSR codes that will display on the screen. The user has 5 check
>> > boxes to
>> > select task code for each of these 63 codes. He can only select 1 from
>> > the 5.
>> > I would then like to take the populated check box and write it to a
>> > permanent
>> > table.
>>
>> use an append query that uses the checkboxes to filter the data.
>> then create a delete query to delete those records from the original
>> temp table once completed.
>>

Okay, thanks. I appreciate the help.

"Michelle" wrote:

> How do you write records from a temporary table to a permanent table.
> I have a one to many form where I am trying to have the user select which
> task code they want for a given task. These are in a subform. The subform has
> 63 DSR codes that will display on the screen. The user has 5 check boxes to
> select task code for each of these 63 codes. He can only select 1 from the 5.
> I would then like to take the populated check box and write it to a permanent
> table.