Automatically refreshing the form

[mark curtis]

Dear All,

Can anyone tell me that for example
If I change a finance figure for which other fields on that form are calculated, On exit of that field can I refresh the form, thus changing any calculated fields accordingly. I know there is some VB Refresh?

Thanks
Mark

 

[taber13]

If all of your fields are being Sumed in one txtbox, you might try adding a After Update Event that will do the following!

After_Update_Event
'Update the Total based on which Value you modified
stDocName = "txtboxthatsumsall"
DoCmd.Requery stDocName

 

[Ernie Taylor]

An even simpler method is create a macro with only requery selected and call this using the properties event for the control. It is not as selective but it will work in most instances and it has the benefit that it can be used for other forms with no change.