How to get Started Using Microsoft Access Even if You've Never Used it Before by Paul Barnett - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

You should enter information on the main form first and then the sub form.

00053.jpgThe selectors at the bottom tell you how many records you have

I have now added an additional field to the sales table called ‘Price’. We will use this field to enter product price data on the subform. Ideally we would want to create a dropdown which selected the product and automatically dropped the price in the subform, but I will show how this is done in another tutorial.

So now our screen looks as follows: 00054.jpg