Before Update event problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with 2 text boxes A and B. A is bound and B is unbound. A is
locked and B is unlocked. All updates are made in textbox B and when the
record is saved B is appended to A.
The problem is that if I enter text in textbox B and then immediately
navigate to a new record, the text in B does not get appended to A presumably
because the control is unbound.
How can I get the contents of B to append to A when I navigate to a new
record?
 
Could you use the AfterUpdate event for B instead to set A after B is changed?
This isn't quite the same but you could code around the possibility that B
was changed more than once. How about adding a Save button to allow the user
to explicitly tell the program when to append B to A? You could also replace
the normal navigation buttons with your own controls along with a form event
(On Deactivate) procedure to do what you're suggesting.
 
Thanks for the response!
What I did was in the afterupdate event for the control appended a space
character to the bound control value. this sucessfully triggered the before
update event for the form where I appended B to A.

-Dorian
 
Back
Top