Initial review and I have the following information or questions:

I would like the form titled "form open" to open when I run the database.
Under the tools -->Startup select the form you wish to have open when the database opens.

the "add new movie" button opens the add new movie form.
Use the wizard for command buttons to Add a new Record

the search movies button opens a new form to search for a particular movie
Use the command button wizard here to open a new form and then use the following tutorial for developing a customized filter to search for a particular record.

http://www.datapigtechnologies.com/f...tomfilter.html

or use the next tutorial if you want an alternative

http://www.datapigtechnologies.com/f...earchform.html

the show all button should just open the table behind the database.
Use the Form Wizard to build a form bound to the table holding the data and set the form to Datasheet view.

in the add new movie form I would like to use the add movie button to add a new record, when the new record form opens the movie# field needs to generate automatically with the next number in the sequence based upon the last number in the ID field. (thought I could do this by linking the movie# field to the ID field in properties).
Why have a separate movie number. Why not use your ID as your movie number and set it to autonumber in the table.

and obviously the return to main menu button will close the form and return to the "form open" form.
Again use the command button wizard to close the form. Any other form still open will appear from behind the current (form having focus).

Once you have accomplished the above post back with any questions you may have.