Updating records between subforms

[IpeXeuS]

Hello there,

I've one question about subforms and records. Ok, I've main form where's 2 subforms init, basicly I 1st subform is for add new records only and 2nd subform is to modify & delete records.

So, what I try to do here is that when user adds new record to subform 1 and click check box, current record will automatically update to subform 2 and application will clear subform 1 for new records. Now I wonder is this possible to complish and if it is, what's easiest way to do this?

All advices are gratefully approciated, thanks!

 

[jmrSudbury]

That is possible. When they click a button on the bottom of subform 1, check the data, then do an insert query (and a delete from subform 1's table) to move the data to the table of subform 2. Requery the second subform to be able to see the new data. If you don't want to move records, or if you want to move to the new record, then change your sorting, or set the bookmark for subform 2.

John M Reynolds