text: i need standard coding examples of ms access?   select tblmain.[dvd title], tblmain.genre, tblmain.[actual dvd], tblmain.[backup dvd] from tblmain where (((tblmain.genre)="drama")) order by tblmain.[dvd title];  -this is sql coding for a query i have created for a database project.  here's an example of vba:  private sub cmdopenanime_click() on error goto err_cmdopenanime_click      dim stdocname as string     dim stlinkcriteria as string      stdocname = "frmanime"     docmd.openform stdocname, , , stlinkcriteria  exit_cmdopenanime_click:     exit sub  err_cmdopenanime_click:     msgbox err.description     resume exit_cmdopenanime_click      end sub  -this is a vba example of coding to link a command button to a new form in access.