Open the Order Details subform in Design View. Set the Default View property to
Datasheet View. Look at the form in Datasheet View mode to see how it looks. You can
adjust the column widths by clicking the heading of the column and dragging the vertical
border to one side. Make sure the Selection type of the Property Sheet is set to Form before
looking at the Default View property.
Notice that the drop-down for products still works as before. Save the subform and close
it. Open the Orders form again and you will see that your subform has now become a
datasheet, as shown in Figure 9-4.
Users may find it easier to view the order details this way, since it is immediately apparent
how many rows there are on each order.Datasheet View
The Form view is ideal for a small number of records, such as the customer table, where the
user is browsing from one customer to another.104 Microsoft Access 2010 VBA Macro Programming
Figure 9-3 Form View of the Orders form with the Order Details subform