On Subform Exit

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I want to set a value for a field based on a calcualted control. Here is my
VBA Statement.

Forms!Loads!Rates!RateAmount = Forms!Loads!Rates!LineHaulRate

LineHaulRate is the calculated one. When I put the command in On Exit
Subform, it properly changes the value but doesn't exit. When I tried the
command in Lose Focus or Deactivate, it fails to respond.

Can someone either tell me how to work this? The subofrom is on a tabbed
page and the exit would be to go to another tabbed page with another
subform.

Thanks!
Mike
 
I suggest you move the formula to the After Update event of the control that
triggers LineHaulRate to change
 
I tried that, but it didn't change anything. I have a command button that
runs it also, can I make the command button click on exit?
 
Back
Top