Hi Everyone,

I am currently working with a split form in Access 2007. I don't know if it is possible, but when I go to update an existing record, The record on the bottom table area still has the old record values until I click on the record down there.

I know for new records it will show as soon as, changes are made in the upper form area. Is there a way to do this while updating a record ?

Thanks,

John

you probably need to trigger it to requery or refresh

look up these two methods in the Access help for more info