• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Exploring Forms and Controls > Another Way to Create Calculated Cont...

Another Way to Create Calculated Controls

You can also create a calculated control using a query. If you have the Customers table from the Music Store database in the query grid with the Customer and Address fields already in the grid, there is an empty spot to the right of the Address field. In the field row, type CSZ: [City] & ", " & [State] & " " & [Zip; then click the drop-down box of the New Object button, as shown in Figure 5.19, and choose AutoForm. The program creates a field called CSZ. A query and a form titled Calculated Field Example are in that database. Notice that the control source for that field is CSZ, as opposed to the expression in the query.

Figure 5.19. Use the New Object button to create a calculated field in a form.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint