Refresh data after search

  • Thread starter Thread starter AKA Sparkticus
  • Start date Start date
A

AKA Sparkticus

I want to refresh the database so all records are available after search but
not sure how to do..
I just want to add a button to a form to do this but I can not get it to
work..

Any help appreciated
 
I think that pressing F9 refreshes the current form / query.
In code, you want to use Requery method.
Pavel
 
IWhat I need the data base to do is refresh it data so that all records are
now viewable and go back to the first available record...
The refresh button does not seem to do this...

Sparkticus
 
Database per se does not "refresh its data". It simply stores the data.
A form or a query can be refreshed to show data that were added or
altered after the form or query was visualized. To accomplish this, use
the Requery method, which is described in VBA help in great detail.

Good luck,
Pavel
 
Back
Top