Hi everyone..
I'm new with microsoft access, and i'm learning how to use it..
i've been given a task of creating a data entry system using the microsoft access 2007...
I want to know how to create a button which have the function of creating new report when we click it..
And can we make it ask we to choose which field should be included in the report?

Hi,


When I ask for the step-by-step, this is what I was expecting:

1. While in Form's Design View, added a Command Button
2. While the Command Button is selected, in the Properties Window, in the Event Tab, selected [Event Procedure] from the dropdown in the Click event
3. Clicked on the three dots (...) next to [Event Procedure]
4. In the Code Window, created the following:

Private Sub ButtonName_Click()
DoCmd.RunCommand acCmdNewObjectReport
End Sub

Hope that makes sense...