click action assistance

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

Guest

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
 
When you click on a textbox it is OnMouseDown focus. Place your code in this
event.
 
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
Click to expand...
[quoted text clipped - 5 lines]
thansk,
tiffer
Click to expand...
Click to expand...
 
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
Click to expand...
[quoted text clipped - 5 lines]
thansk,
tiffer
Click to expand...
Click to expand...
 
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.

jahoobob via AccessMonster.com said:
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
Click to expand...
[quoted text clipped - 5 lines]
thansk,
tiffer
Click to expand...
Click to expand...
Click to expand...
 
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.
Click to expand...
[quoted text clipped - 10 lines]
Click to expand...
 
Back
Top