the RecordSource can later be changed to an SQL statement if desiredĥ. make a form based on the query just created Line up the data using one or more queries 4. envision the statistics you want to show on a subform 3. Please Like, Comment, and Share with your friends ~ See how aliases are used for tablenames and calculated field names and how a Left Join displays graphically with an arrow.Īnd finally, see the magic of Access happen ~ Switch between SQL View, Design View, and Datasheet View.
Get an understanding of the different query views. Take a deeper look at the SQL statements that Access stores when you create queries. See how queries are stacked to get statistics from multiple tables that are not directly related into one place. The RecordSource for the subform (where it gets its data from) is a query that has 2 queries below it doing more calculations. The form inside the subform control is a regular form designed to be used as a subform and in this case, to display information only, so things like RecordSelectors and ScrollBars are turned off. What is displayed in the combobox is influenced by Column Count, ColumnWidths, and ListWidth. On the mainform, LinkMasterFields is a combobox that stores CustomerID but shows the customer name and more. LinkMasterFields and LinkChildFields are used to synchronize the forms, without any more effort on your part! Its properties specify: what it contains (Source Object), how it is linked (Link Master Fields, Link Child Fields), what it is called (Name), how big it is (Width, Height), where it is (Top, Left), what it looks like (Border Color, Border Style, Special Effect), whether or not it shows (Visible), if the user can modify values (Locked, Enabled), and so on.Īs you navigate from record to record in the mainform, data in the subform automatically changes. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.Ī Microsoft Access subform is used to show relevant calculations for data in the mainform.Ī subform control is a container, like a bucket, for a form or report. Look below the covers at a subform control, and the form that is inside it.