Before Update event problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 22 Mar 2007 19:25 GMT

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?

Reply to this Message

kingston - 22 Mar 2007 20:20 GMT

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.

>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
[quoted text clipped - 4 lines]
>How can I get the contents of B to append to A when I navigate to a new
>record?

Reply to this Message

mscertified - 22 Mar 2007 22:18 GMT

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

> 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
[quoted text clipped - 11 lines]
> >How can I get the contents of B to append to A when I navigate to a new
> >record?

Reply to this Message