Refresh Data in a continous form without changing the view

W

Warrio

Hello!
Is it possible to refresh a continuous form so it gets the data that was
updated on another form using a requery or another function without that the
position of the record selector changes

even if I store the position of the current record (using myPosition =
me.recordset.AbsolutPage)
then the requery and finally Docmd.GoToRecord , , , myPosition

with that, if the record was in the middle of the form, the requery makes it
move to the top of the form

Is there a function that refreshes the data without changing anything in the
user view?

Thanks for any advice!
 
W

Warrio

yes I did! it doesn't have the same effect! the Refresh doesn't even reload
the data from the tables
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuous form refresh/requery 3
Need combo box to refresh when moving to new record 2017 1
Refresh data in sub forms when one sub form is edited 4
Continuous Form Records question 2
Requery single record in datasheet view 9
Refresh, Requery, Repaint?? Which One? 1
refresh an open form using records from another open form? 26
Viewing the current record after requery a form 2

Top