Automatically Copy Data from one text box to another

  • Thread starter Thread starter Shiller
  • Start date Start date
S

Shiller

Experts,

How do you go about copying data from one text box to another on the
same form. One text box is an unbound text box and the other one is
bound to a table.

I tried using the following in the after update event but it wouldn't
work: Me.textBox1 = Me.textBox2

Thanks
 
First, why are you using the After Update event? Is there a specific reason?
Because in the On Exit event for the "source" textbox, you can place your
code to populate the "destination" textbox, and expect it to work.
 
First, why are you using the After Update event? Is there a specific reason?
Because in the On Exit event for the "source" textbox, you can place your
code to populate the "destination" textbox, and expect it to work.
Click to expand...

Dennis,

I found previous posting by some some experts that recommended to
place the following codes in the after update event of the text box
being used as the source:

Private Sub txtBox1_AfterUpdate()

Me!txtBox2 = Me!txtBox1

End Sub

That was supposed to update txtBox2, but I've been trying all morning
long and it's not working. I also tried the after exit and it didn't
work either.

do you have any idea why?
 
The After Update event is the correct place to do what you are doing.
Your code appears to be correct, so I don't see what the problem is.
Are both text box controls bound or unbound?
 
First of all, "After Update" refers to after a record has been updated, and
has nothing to do with an unbound field. For an unbound field, I'd use On
Exit or On Change. Secondly, your syntax SHOULD WORK if used in the correct
event.

Is the BOUND field your source or destination field? If it's your
destination field, you need to place the source text into it before you
attempt to update/add the record. Have you single-stepped through the code
and hovered over the field(s) (or set them as Watches) to determine the
value(s) in it/them? If not, I suggest you do so.
 
You are correct that the After Update event does not fire for unbound
controls; however, it is more usual to use the Lost Focus event when the
controls are not bound.

You comment on After Update is half correct. If you are talking about the
Form After Update, then yes, if it is a control After Update, it is specific
to the value in the bound control.
 
Thanks for that clarification. I figure that if I hang out here long enough,
SOMEDAY I might have a good understanding of how Access works. (Probably just
in time for MS to retire the product. *sigh* )
 
LOL
hanging out here is a good thing. I have learned most of what I know in
these newsgroups.
 
LOL
hanging out here is a good thing. I have learned most of what I know in
these newsgroups.
Click to expand...

I just found out that the data copies to the new text box if I click
on the source text box then click on the destination text box. I know
I'm getting close to finding a solution.

*the source text box is unbound and the destination is a bound text
box*
 
I just found out that the data copies to the new text box if I click
on the source text box then click on the destination text box. I know
I'm getting close to finding a solution.

*the source text box is unbound and the destination is a bound text
box*
Click to expand...

Thanks guys,

I finally got it work last night. I want to be an expert like you
when I grow up. :)

Shiller,
 
LOL
hanging out here is a good thing. I have learned most of what I know in
these newsgroups.
Click to expand...

Hello,

I used the on current event of the main form to store the data
directly into the field I needed, without needlessly displaying it on
the screen:

Private Sub Form_Current()

Me.DestinationField = Me.txtBox1

End Sub

I was going about doing this the hard way, thanks for your your input
I cracked it. I want to be an expert like you
when I grow up. :)

Y'all my heroes... :)
 
Back
Top