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

  • Thread starter Thread starter Mary B.
  • Start date Start date
M

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
 
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
 
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>




.
Click to expand...
 
Back
Top