Me.Refresh and Me.Requery

  • Thread starter Thread starter Robert
  • Start date Start date
From the Access Help File:

In an Access database (.mdb), refreshing records only updates the data that
already exists in your datasheet or form. It doesn't reorder records, display
new records, or remove deleted records and records that no longer meet
specified criteria. To perform those tasks, requery the records.


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
Thank you.
boblarson said:
From the Access Help File:

In an Access database (.mdb), refreshing records only updates the data
that
already exists in your datasheet or form. It doesn't reorder records,
display
new records, or remove deleted records and records that no longer meet
specified criteria. To perform those tasks, requery the records.


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
Click to expand...
 
You must log in or register to reply here.

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

What's the difference? 2
filter on a form only works once 5
ServerFilter problem - why doesn't this work? 1
Lockbox works BUT... 2
It Says NO CURRENT RECORD 2
REFRESH / REQUERYCODE - PLEASE HELP.. 2
Recalculating Subform 4
run time error -2147352567 1

Back
Top