refresh

[Dan]

i have a form with 3 subforms in it. my problem is i may
change data in one of the subforms and want it to refresh
once i move to the next field but it doesnt. if i change
the data then hit refresh at the top or requery (shift F9)
it refreshes right away is there code or a macro
that can help me do this ? i know there is a macro
requery but not sure what property to use or how to do
it your help is greatly appreciated

 

[capinvest]

Try:

Me.Refresh

Before your code in VBA.

 

[Dan]

what is the me?

-----Original Message-----
Try:

Me.Refresh

Before your code in VBA.

.

 

[rameshmenon]

Me is a standard value in VB.

For example to refresh the code you use

Me.Refresh

To Unload a program you use

Unload Me