I want generate and load the report using vba when a command button is clicked . (automating the report generation)
For example i have table in access that has name, address and email fields and onced command button is clicked the report is
generated and loaded.I be happy if some one show me working example.Thanks

Firstly, write the report and then add a new command button to your form... doing this will fire up the "Command Button Wizard"... simply select "Report Operations" and then select your "Report Preview" or "Print" or whatever.