Every database has a group of forms where each form can do three things:
Data entry (add new records)
Edit existing records
Delete existing records.
For example, in an orders form/subform, you can enter new orders in the main
form and the order details of a the new order in the subform. To do this,
all you need do is click the main form new record navigation button. If you
note a data entry error later in the order record, all you need do is use
the main form navigation buttons to find the order and then edit the record.
If you note a data entry error later in an order detail record, all you
need do is use the main form navigation buttons to find the order, use the
subform navigation buttons to find the order detail and then edit the order
detail record. If you need to delete an order later, all you need do is use
the main form navigation buttons to find the order and then delete the
record. If you need to delete an order detail later, all you need do is use
the main form navigation buttons to find the order, use the subform
navigation buttons to find the order detail and then delete the detail
record.
Then there are another group of forms for displaying desired information.
For example say you want to view all orders in October 2007. You need a
parameter query that returns the order fields you need and where you can
specify the year and month of the order date field. You then create a form
that uses the query as the recordsource and includes the fields in the
query.
Finally, there may be forms that supply the parameters to queries like the
above.
Steve
"Tyler" <tyler.horning (AT) gmail (DOT) com> wrote
Quote:
Made a data entry form which is a subform. I made a continuous form
that displays everything entered through the data entry form. The
data entry form displays all of the records. This doesn't make any
sense because it is a data entry form... am I missing something?
Thanks. |