transfer data from a form to table

[aljubury]

I want to ask if I can transfer data (rows) from a form to a table other than the one bounded with the form?

I need to transfer specific rows only, can I??
for neccesary!

[Seth Schrock]

Yes it is possible, but if you have a properly normalized database, then it is very rare that you would need to.

How do you pick which rows that you want to transfer?

[aljubury]

sorry I didn't get you,
suppose we have a form for costumers details and every month we have to choose some of them and put their details in separate table, how we gonna do this
I am thinking if we can put an button in (detail) part in the (design view) and give a command whenever you click on it will transfer this row (details) to a specific table .

[Seth Schrock]

I would use the Insert Into Select query to do this. The basic syntax is

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1
WHERE ID_column = Current_ID

The On_Click event of your button would build this string and use the value in the ID control for the current record to replace the Current_ID in the syntax above.

[aljubury]

can you explain more please,,

[Seth Schrock]

Without more information I can't be too specific, but here is about what you need.

Dim strInsert As String
Dim db As DAO.Database
 
strInsert = "INSERT INTO table2 " & _
            "(column_name(s)) " & _
            "SELECT column_name(s) " & _
            "FROM table1 " & _
            "WHERE ID_column = " & Me.ControlName
 
Set db = CurrentDb
 
db.Execute strInsert, dbFailOnError
 
Set db = Nothing

Table2 is the table that you are inserting into . Table1 is the table that the information is coming from. Me.ControlNumber is the control whose Control Source is the ID field for your table.