Changing Value of a control after updating another one

  • Thread starter Thread starter Veli Izzet
  • Start date Start date
V

Veli Izzet

Hi all,

I want to change the value of a control (ControlToChange) to the value
of another control (ControlThatChanges) after updating this control.

In another words I want (ControlToChange) take the value of
(ControlThatChanges) after I input data to (ControlThatChanges).
Both the controls are on the same subform.

I tried to write a macro with GotoControl and SetValue but it didnot work.

Thanks for any help..
Regards
 
The macro would be just one step:

Action: SetValue
Control Name: ControlToChange
Expression: [ControlThatChanges]

Assign the macro to the AfterUpdate event of the ControlThatChanges control.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
change value After Update 1
Help on Help 3
Macro Not Triggering After Update Event 6
Copy a value of a control on a mainform to a control on a subform. 2
An alternative to SendKeys --"KeyStrokes: {F9}" Wait: "Yes" 8
Setting default value of control on form to the value of another c 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top