Requery or repaint to update all control values on a form together?

[tvsmvp]

Is there a way to force all the controls on my form to update to current values simultaneously whenever I change a value somewhere on my form (via any and all controls)? I'm ending up with a bazillion strings of identical code, each attached to the event of several controls - when there's gotta be a way to force everything to update. I'm betting there's a way to force all the controls on the form using "requery," or "repaint"... something like that.

 

[Remou]

So which one did you try?

 

[tvsmvp]

I've been trying to make "requery" work - which does when I use it per control. That is, I can tell it to do a requery in the event code for a particular control (and it updates that particular control) but naturally it doesn't update the other controls. I'm trying to figure out, then, what the code would be to "requery" all controls on the form together.

 

[Remou]

Try
Me.Refresh

 

[TheAceMan1]

tvsmvp . . .

. . . or in a button try:

[blue]   Me.Requery[/blue]

See Ya! . . . . . .

 

[PHV]

You may consider Me.Recalc

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886