Using command button to query and open form

[annienelson621]

I very little experience with Access, and have been asked to create a student discipline database for my school. I have starting using another database I found, and am attempting to modify it in a way that works for my teachers. I have made a table with student information, and then I have made a discipline for that has a record for each student. I would like to be able to use a command button to pull up a student's particular record (form) by entering their student ID number (which is listed in the table).



I have created a command button on form I am using as a switch board. I would like to be able to click on the command button, be asked for the student's ID number and then have it pull up the student's discipline form (that I have already created). I have been playing with creating a macro, but have been unsuccessful. Any help or direction would be appreciated!

[ranman256]

click the button in design mode,
in the properties sheet
goto the EVENT tab
in the ON CLICK event, drop the box to make a new macro
in the macro use the command OPENFORM fStudents
save the macro
save the form.

[annienelson621]

Thank you for the quick response! When I try that, it pulls up the first student's form, which is definitely a step in the right direction. Is there a way to make it so that when I click on the button it prompts me for the parameter value of the student ID number and then pulls up that student's form/record?