Next, click in the field name of the first column. The column will be highlighted. All columns between the first and last will be highlighted. Those frozen columns will stay on the screen as you scroll to the right. Forms draw their information from either a single table or a single query, but only one.
Forms can do calculations, or can be used to report calculations from queries.
However, you cannot enter new numbers in those calculation areas. The form only lets you change the underlying raw data. Suppose a query is based on a table, and a form is based on the query. If you change information on the form, the information from the form is passed back to the query, and the query passes the information back to the table. The result is that changing information on the form changes the information in the underlying table.