Submitt Button

[petenyce105]

I have a form with fields. Now i have a add new record button which workds fine. But i want certain records to submit to another table? How could i have a button that sends that record to a different table. the table im using is called id cards and the table wher ei want the information to go to is Order Id Card?/??? Any help would be great

thanks

 

[PHV]

You may consider a simple append query:
DoCmd.RunSQL "INSERT INTO [Order Id Card] (field1,...,fieldN) SELECT col1,...,colN FROM [id cards] WHERE SomeConditionDeterminingTheRecord;"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[petenyce105]

I just want to submit the current record to a new table by a command button . So if their is 3000 records i can just submit the records i want into this new table.
the table is Id Order card.

So when the user presses the button it submitts the record into this new table

thanks
Pete