From the course: Microsoft Access: Forms and Reports

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Design the form controls

Design the form controls

- Our query is built. The report is designed. Now it's time to build in the controls. That'll allow our end user to customize the report by selecting the month and the year that they're interested in seeing. Let's close the Profit Summary and open up the main menu form. Instead of creating a new form for this, we're just going to make use of the blank space that we have on the right hand side of this. Here we can place a couple of controls that will allow the end user to select the month and year that they want to see in the report. Let's go into design view. Now there's a number of different controls that we could use for this. I could use a text box control, in which case the end user would have to type in the name of the month and year that they want to see. Alternatively, we could use a combo box or a list box control and allow them to make a choice from the listed options. I'm instead going to use an option…

Contents