refresh

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

i have a form and a sub-form the main form has all
the generic data on it and the subform has amounts that im
adding a total at the end i want to be able to have
the total change as soon as i change one of the amounts in
the subform. It will not do it until i go to another
record then go back is there a way i can have this
update as soon as i hit enter
 
Dan,
You'll need to do a Refresh, or a Requery, after altering or entering
your subform records. (ex. you could trigger off the AfterUpdate event).
That will force the Subform to recalculate any values if you change the
data.
 
i did put a refresh button on my form and it works but i
was hoping that i could just get it to update after i
change an amount in my subform. i tried using the after
update property in my subform and using a macro but i
cant seem to get it to work any help is appreciated
should i be using code?
 
Dan,
I wrote...
You'll need to do a Refresh, or a Requery, after
altering or entering
your subform records. (ex. you could trigger off the
AfterUpdate event).
Click to expand...
Let's say you have a field in your subform called Price, and whenever the
Price changes, you want to update a Total in the subform.
Select the AfterUpdate event for Price, and place this code behind it.
Refresh
Every time you change/add/delete a Price, the subform will Refresh and
display the correct totals.
 
i did create a button on the form to refresh and it works
but i was hoping that when i make a change in the subform
and hit enter or tab that it would change automatically.
i did try using the after update event in the properties
of the subform using the requery action macro but cant
seem to get it to work do i need code im not sure
what afterupdate is? im not sure what im doing wrong
or if this is even possible?
 
Back
Top