refresh\requery part of form?

  • Thread starter Thread starter martin
  • Start date Start date
M

martin

I have a large very complicated form that takes a long
time to requery\refresh. Is it possible to only
requery\refresh certain fields on the form after I add new
data? Or is it possible to put a text box with a new
calculated value on a form without requerying the whole
form?

Thanks
Martin
 
Martin,

You can requery individual controls:

Me.ControlName.Requery

HTH,
Nikos
 
Nikolas,
can you please be more specific. I think I share the same issue with Martin. I would like to avoid form reload in the same time I want to show database changes in data grid control. In other words, form stays the same, but data presented on the form changes automatically in scheduled time interval or with click on the button without reloading the page. What do I do?
Please advise.

Thank you, Aleksanda
 
Aleksandar,

You could use the timer event on your form to do this. The code line in the
Timer event should be:

Me.ControlName.Requery

where ControlName is the actual name of your data grid control. To do sthis,
open the form in design view, display the form properties window, go to tab
Events and scroll all the way down. Set the timer interval to, say, 1000 (=
1 second), then go to the On Timer event right above it, select Code Builder
and add the above line of code.

HTH,
Nikos

Aleksandar Andjelkovic said:
Nikolas,
can you please be more specific. I think I share the same issue with
Click to expand...
Martin. I would like to avoid form reload in the same time I want to show
database changes in data grid control. In other words, form stays the same,
but data presented on the form changes automatically in scheduled time
interval or with click on the button without reloading the page. What do I
do?
 
Back
Top