Want to open a new form from an existing form

[kpalar]

I have created a form with combo box and a sub form. The data varies according to the field I changes in the combo box.



Now I want to open a new form using a command button from this form, where I need the same data on that form.

Please advise

[pbaldy]

Like this?

http://www.baldyweb.com/wherecondition.htm