Marc: The following is just a rough layout of two solutions. the blanks to be filled in are straight forward.
one simple way to do this is create a query that copies the data from one table to the other (an append query), then a second query that deletes the data from the first table. they would use a parameter equal to the wish # or something unique in the first table. practice with the queries on a copy of the database. add 2 buttons to a form that would have a parameter field (maybe even a drop down), one button for each query. You might get some further ideas from articles on my web site. (fancier yet would be a little VBA that would run both queries, one after the other) Alternatively, only have one table, with a flag that indicates if the wish is fulfilled. Richard "Manxman" Killey Developer of MS Access Databases mailto:[EMAIL PROTECTED] for more MS Access tips, visit http://www.databaselessons.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Marc Sent: December 2, 2008 12:46 PM To: [email protected] Subject: [Access VBA Central] help is needed moving data between tables We area non for profit org that fullfills wish lists for children infected /affected by HIV we have a access datbase that tracks all the requests and needed information per child What our issue is we would like to do is once the request is fufilled is there a way to move the data from one table to another wish only shows in subforms without retyping all the information of the request again? this is all done with subforms is it at all possible? [Non-text portions of this message have been removed]
