move record

[spalla]

i have a database with 2 tables one for active clients and one for client that are not active anymore. How can i move one record from one table to the other if a certain field is set to "inactive"
i'd like to do that from a form
anybody can tell me how?

 

[ToeShot]

This is not a detailed answer but it is a starting point. you would need to create a update table query. search the record so it updates the table the make a delete query to delete it from the original table.

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[spalla]

could you be a bit more specific?

 

[PHV]

Something like this ?
DoCmd.RunSQL "INSERT INTO [inactive table] (field1,...,fieldN)" _
& " SELECT col1,...,colN FROM [active table]" _
& " WHERE [certain field]='inactive';"

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