Want to use DoCmd to bring up correct record

[hals]

I have two tables: STUDENT with primary key Student ID, and ALUMNI with primary key Alumni ID. They have a 1-to-1 relationship, Student ID is AutoNumber (system generated number), and Alumni ID is a Number of type Long Integer. When working in the STUDENT form, I have created a button called, View/Update Alumni. When I click on this button it asks for the Student ID number, and when I enter the Student ID, the correct Alumni record comes up. I am using the code:

DoCmd.OpenForm "ALUMNI", , , "[Alumni ID] = [Student ID]"

Is there a way for the DoCmd to bring up the correct Alumni record without requiring the user to enter the Student ID?

Thank you for any help,
Hal S.

 

[Ellasar]

Create an hidden textbox in with the controlsource Student ID With the name Student

Edit the line to:
DoCmd.OpenForm "ALUMNI",,,"[Alumni ID] = " Student.Value

 

[RayMan]

When the student is display Store the key in a variable global to the form.

Rayman