Refresh data after search

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
 
P

Pavel Romashkin

I think that pressing F9 refreshes the current form / query.
In code, you want to use Requery method.
Pavel
 
A

AKA Sparkticus

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
 
P

Pavel Romashkin

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
 

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

WORD VBA Search and switch to advanced ... 1
Help creating a search form in Access XP 0
Delete all data after a symbol in a field 0
PLEASE HELP: Refresh a subform 5
Outlook calendar list 0
Create tool bar 2021 0
"Compile error in table level validation expression " after format 0
Need Help with Macro Security 1

Top