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!