One button to refresh all forms and subfroms at once ?

[lesaint]

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

 

[pono1]

lesaint,

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

me.recalc

Regards,
Tim

 

[JackG]

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

Thanks

 

[pono1]

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

 

[lesaint]

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

 

[lesaint]

Well, I found partially the solution myself.

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


Tx though

greetings