SetValue

R

Ray Hogan

Hi,
Please advise whwere I can get info on SetValue and a typical application on
a Form.
Thanking you in anticipation.
Rayh
 
K

Ken Snell

What do you want to know? There is info in the Help files about SetValue....

Give us more info.
 
R

Ray Hogan

I wish to transfer data from Form to subform before I change data in Form.
Thanking you
Rayh
 
K

Ken Snell

In a macro, such a SetValue action would look something like this:

Action: SetValue
ControlName: Forms!MainFormName!SubFormName!ControlName
Expression: Forms!MainFormName!MainControlName

where MainFormName is the name of the main form, MainControlName is the name
of the control that holds the value that is to be copied, ControlName is the
name of the control in the subform that is to receive the value, and
SubFormName is the name of the subform control on the main form (the control
that holds the subform object).
 
R

Ray Hogan

Hi,
Which action would it be best to include the Macro- On Enter, On Got Focus
etc.
Regards.
Rayh
 
K

Ken Snell

The "best" event would completely depend upon when you want to save the
value, what you're doing prior to that, etc. Can you tell me a bit more
about the process that you want to follow for this operation?
 
Top