Very simple question- moving records into a table

[Benjamin Bolduc]

Hi everyone,

I'm having some syntax problems with a form I'm working on. I have a form with a combobox and all I have to do is send the records that I double-click to a pre-made table. (Like coping and pasting). Seems easy enough? Well it probably is, but I've never done it before and once again, Id like to stress how useless Access help is. (At least for me)

If someone could give me a syntax example for doing this, you'll be my hero for the day. Thanks a bunch!

-Ben

 

[Fizzio]

Why are you copying records to a new table (this is not a criticism)?
To copy the records, there are a couple of ways you can do it.
1) use an append query
2) use a recordset.

Depending on what you are trying to acheive may give a slant on the preferred method.

 

[Benjamin Bolduc]

Thanks for your reply

Basically I want the records to be copied temporarily to a blank table so I can add feilds and change the data as needed (Via a form that is based on it) . Then I'd use an append query to paste the new, updated records into a main table. After that, Id have a delete query erase all the records that were sent over to the first table.

The append/delete query on the form is easy, I just dont know how to get the base records from my combobox to the temporary table.

Thanks!
-Ben

 

[dgm]

Hi Ben,
I'm not sure you need to do all this. You should be able to open the form (which is based on the Main table) and filter the records so only the record from the combo box is displayed.
That's if i'm understanding you correctly, and it's highly probable that i'm not.

Dave