Looks like you have to use VBA to select the record, insert it to the other table, and then deleted from the first table.
The other way is to create a new field on both tables and changing the flag for each depending on the completion of the record. The only issue is to have the tow tables updated. After reading you post again, it may be that you just need a single flag in one table which just displays it as completed in your subform. Oh well. Good luck. Mike- --- On Tue, 12/2/08, Marc <[EMAIL PROTECTED]> wrote: > From: Marc <[EMAIL PROTECTED]> > Subject: [Access VBA Central] help is needed moving data between tables > To: [email protected] > Date: Tuesday, December 2, 2008, 9:46 AM > 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? > > > > > ------------------------------------ > > Yahoo! Groups Links > > >
