Simple Macro question....I think....

[Mary B.]

I need to do 2 things in my database that I am not sure
how to do.

1. If 'x' is selected in my drop down menu, open
form '2' If 'x' is not selected then do nothing.

2. When condition 1 (above) above is true, after opening
form '2' copy field 1 in form '1' to field 5 in form '2'

any advice... I haven't had a lot of success finding the
answer to this question.

Thanks tremendously.

Mary

 

[Ken Snell]

Use the AfterUpdate event of the combo box to run this macro:

macComboBox

Condition: Forms!Form1!cboBoxName.Value = 'x'
Action: OpenForm
Form Name: Form2

Condition: . . .
Action: SetValue
Control Name: Forms!Form2!Field5
Expression: Forms!Form1!Field1

 

[Mary Bell]

Thank you so much!

-----Original Message-----
Use the AfterUpdate event of the combo box to run this macro:

macComboBox

Condition: Forms!Form1!cboBoxName.Value = 'x'
Action: OpenForm
Form Name: Form2

Condition: . . .
Action: SetValue
Control Name: Forms!Form2!Field5
Expression: Forms!Form1!Field1



--
Ken Snell
<MS ACCESS MVP>




.

 

[Ken Snell]

You're welcome.

Thank you so much!