Set Value Look-up?

[Dan Lavish]

Ok I am going to try and explain this the best I can.. I have two
forms the first form I have has a field on it that is based on another
small table called part supplier on the second form i have another
field that is called To but it is a list of the part suppliers
addresses i want to have a macro or some on click event that when i
click a button on the first form it opens the second form and looks up
the address with the part supplier name (both are the same) any help
would be cool
Thanks, Dan

 

[Tieske]

I think there is even a wizard for this.

first create your "second form"
next create your "first form", on this form, add a commandbutton and follow
the wizard to have it open a form based upon a value selected in "first
form"

that's all there is to it.

regards,
Tieske