Automatically refreshing the form

mark curtis

Registered User.
Local time
Today, 23:31
Joined
Oct 9, 2000
Messages
457
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
 
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom