Using selected item to search new form

[Nolan Adams]

I have a form that has a list box which the user selects one item and then clicks on a 'button'. The code on the button then displays another form which should only display the records for the 'selected' items of the first selection. How do I get the 'selected' data to limit the rows returned on the second form?

The first form lists student names (Table1). The second should show only the records for that student from another table (Table3).

I am sure this is simple, but since I am more simple I need help. Thanks

 

[krunalprajapati]

instead of creating two forms with pushbutton to open othter form,
create a form with subform and link the forms with common fields or with the student's name or student's idcode.