Use macro to open form from lookup field

[Guest]

Hi,

Here is my question. I hope someone can help! I am trying to create a macro
that will open a form based on the value a user selects in a lookup field in
another form.

Specifically: Form1 has a lookup field based on its' underlying table. It
has 4 values in it. If a user clicks on the drop-down box and selects Value3,
I want it to run a macro that will open Form2.

Right now the macro will run, but it pops up a parameter box, and makes me
type in the value again, instead of using what is selected in the drop down
box.

Any ideas?
Thanks in advance for any help you can give!
Rose.

 

[Steve Schapel]

Rose,

Do you mean the combobox gives a list of the names of forms? So the
selection from the combobox determines which form yu want to open? Or
do you mean that the selection from the combobox will determine which
record on Form2 you want it opened at? What have you got in your macro
so far? Can you give an example?