click action assistance

[tiffer]

Hi, I have a form set up, among other fields in the form is a Weekly update
free form field. I have another field called Historical Weekly updates. What
I want to happen is that when a user clicks in the Weekly updae field, the
text that is in there should pop down to the Historical field and have the
date post for the move. I think it's a click action, but I am not sure. Any
help would be greatly appreciated!!

thansk,
tiffer

 

[jahoobob via AccessMonster.com]

When you click on a textbox it is OnMouseDown focus. Place your code in this
event.

 

[jahoobob via AccessMonster.com]

Just OnMouseDown, not OnMOuseDown focus!

When you click on a textbox it is OnMouseDown focus. Place your code in this
event.

Hi, I have a form set up, among other fields in the form is a Weekly update
free form field. I have another field called Historical Weekly updates. What

[quoted text clipped - 5 lines]

thansk,
tiffer

 

[tiffer]

Also - not sure how to code it, either.

 

[jahoobob via AccessMonster.com]

Me.Historical = Me.Weekly
asuming those are the names of the two text boxes.

You might want to consider placing this in the Historical boxes OnMouseDown
because, if you click in the weekly field to edit it, the data will be
transferred before the edit.

Also - not sure how to code it, either.

Hi, I have a form set up, among other fields in the form is a Weekly update
free form field. I have another field called Historical Weekly updates. What

[quoted text clipped - 5 lines]

thansk,
tiffer

 

[tiffer]

thanks for all the help....however, when putting the line (Me.Status History
= Me.Weekly Status) in the OnMouse Down field i nthe properties box, I get an
error that says the form can't find theMacro "Me."....that the macro doesn't
exist. I played around a little and went to the macro window, but am now
more confused.

Me.Historical = Me.Weekly
asuming those are the names of the two text boxes.

You might want to consider placing this in the Historical boxes OnMouseDown
because, if you click in the weekly field to edit it, the data will be
transferred before the edit.

Also - not sure how to code it, either.

Hi, I have a form set up, among other fields in the form is a Weekly update
free form field. I have another field called Historical Weekly updates. What

[quoted text clipped - 5 lines]

thansk,
tiffer

 

[jahoobob via AccessMonster.com]

Sorry. I assumed that when you said you didn't know how to code it that you
did know how to code.
Erase what you have in the OnMouseDown property. Select the ellipsis (...)
at the end of the box. Select Code Builder and then OK. This will take you
exactly to where you can enter the code. Close Visual Basic.
It should now work.

thanks for all the help....however, when putting the line (Me.Status History
= Me.Weekly Status) in the OnMouse Down field i nthe properties box, I get an
error that says the form can't find theMacro "Me."....that the macro doesn't
exist. I played around a little and went to the macro window, but am now
more confused.

Me.Historical = Me.Weekly
asuming those are the names of the two text boxes.

[quoted text clipped - 10 lines]