What is that Command Button and how do I use it in Access 2007? At it's most simplistic use a Command Button can be placed on one of your forms, and use it to close the form. So when a user clicks on the button it closes the form. Now in a more complex option of the Command Button you can have it programmed to open up a corresponding, related record. In other words, if a user is on record 22 and they want the details of that record (located in another form), you can program it to open up that related record when that other form opens up; otherwise, the related form will open up, but start out on the first record whether it's related or not from the other form you started on.

Purchase the training video and you can see this in action for yourself!