dbTalk Databases Forums  

data entry form help

comp.databases.ms-access comp.databases.ms-access


Discuss data entry form help in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tyler
 
Posts: n/a

Default data entry form help - 10-09-2008 , 01:52 PM






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.

Reply With Quote
  #2  
Old   
Steve
 
Posts: n/a

Default Re: data entry form help - 10-09-2008 , 03:31 PM






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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.