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.