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

Three Sources

Three properties on a form or report can become sources of table or query data. These three sources can all work together. For example, the form’s record source property can be linked to a table or query. The moment you set the record source of a form or report to a table or query, the fields become available to the form or report through the control source of any text, list, or combo box you place on the form, for example. The row source can become a source of data for the control source of the same control.

Another way to look at it is that you can use the control source to both display data from and insert data into the underlying table. The row source, on the other hand, only displays and retrieves data, unless you program around this. The record source property is available on all forms and reports, but the control source and row source properties are only available on certain types of controls. Table 7.5 explains the differences between the three properties and shows on which objects they are available.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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