One button to refresh all forms and subfroms at once ?

lesaint

New member
Local time
Today, 05:49
Joined
Apr 3, 2003
Messages
8
Hello,

One button to refresh all forms and subfroms at once ?

Does that exist ?
If so how to do that ?

I want A button, when presed, that refreshes all forms and subforms (cause I have 1 main forms containing linked subforms)
So when pressed, you can see the new entered or deleted data, without having to go to a previous 'main record' for instance.


Many tx in advance
 
lesaint,

Try this: Put a button on the main form and in it's On-Click event paste in this code:

Code:
me.recalc

Regards,
Tim
 
Can we assume that the recalc actually dumps the data to the database?

Thanks
 
Jack,

It doesn't say so in the Help file, but yes, it does. At least in Access 2000.

This is relatively easy to test: Create a command button on a bound form, putting the me.recalc line behind it. Now go to form view and change the data in a textbox of an existing record. Open the table the form's bound to, seeing if the corresponding field reflects the new entry in the form. It won't. Close the table. Click the recalc command button and re-open the table...

Regards,
Tim
 
hmm...

It gives the same result as a record refresh.

Main
contact
contact 2

When I change a record in contact form - the result is also shown in the contact 2.

However adding a new record in contact wont show in the contact 2 form, unless I go back and forward in the "main form"

Any help like this ?

Tx allready
 
Well, I found partially the solution myself.

Just put a refresh button on a tab, no in a form


Tx though

greetings
 

Users who are viewing this thread

Back
Top Bottom