Requery Problem - Easy

[Guest]

Hello All,
I have a form (Allocation Summary) with a subform (EntryLedgerSUB). The
there is another form (Invoice Entry) which pops up for data
addition/modification to the data for Entry LedgerSUB. I have set a script to
refresh and recalc Allocation Summary when data is added and the new records
appear. However, there are calculations completed in the underlying Query
which I need to update when the data is updated. I tried to run requery but
the record always goes to the first in the table. Is there something I can do
to make it stick with that table? Any help is appreciated. Thanks, Adam Kemp

 

[storrboy]

Hello All,
I have a form (Allocation Summary) with a subform (EntryLedgerSUB). The
there is another form (Invoice Entry) which pops up for data
addition/modification to the data for Entry LedgerSUB. I have set a script to
refresh and recalc Allocation Summary when data is added and the new records
appear. However, there are calculations completed in the underlying Query
which I need to update when the data is updated. I tried to run requery but
the record always goes to the first in the table. Is there something I can do
to make it stick with that table? Any help is appreciated. Thanks, Adam Kemp

Try Refresh instead or Requery. Not sure if it moves the pointer, but
it should refresh the form and it's calculations without gathering new
data.