You might NOT want to move it from one table to another but rather flag it so it shows in one form and not in the other. I would need more info in order to give you a more detailed answer. Please send a bried description of the data and process involved and/or table structure(s) -- Mario Ricardo Osorio "... Begin with the end in mind ..."
________________________________ From: Marc <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, December 2, 2008 12:46:21 PM 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]
