Button to open form to specific record not working...

[Oimoi]

SOLVED - Button to open form to specific record not working

I have a form that allows the user to drop or transfer classes for a student, and on that form I have a combo box that pulls up fields from the Student table. All of the columns are hidden except for the StudentID. The rest of the information auto-fills nearly into several text boxes.

I tried creating a button using the Wizard that would open the Student form to the specific record that corresponds to the StudentID in the combo box, BUT it keeps opening to a blank, new record. I then tried to have the StudentID auto-fill in a separate, hidden control, and linked that to the StudentID on the Student form, but to no avail.

I have no idea what I'm missing and would appreciate any pointers.

 

[Oimoi]

Not sure if this helps, but the combo box is unbound, and I'm using Access 2010.

 

[Oimoi]

Wow. *smacks forehead* The "On Load" event for my Student form forced it to open to a new record. I'm an idiot.

 

[missinglinq]

...I'm an idiot.

Why should you be different?

Glad you got it working!

Linq ;0)>