How do I create a cmd button that will display a form with data for a specified ID#?

[Daniel B]

I have a search form where I can enter in an ID# and I want to create a command button that, when clicked, it will bring up another form with a subform that displays the data for the ID# that was entered.

Any Suggestions?

Dan B.

[Delerna]

Have the button open a form
Have the form that gets opened bound to a query

In the query that the form is bound to
have the criteria for the ID field bound to the ID textbox on the search form


the criteria will look something like this

forms!YourSearchFormName.txtIDTextBoxName