Forms entry

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have a form that is built and they enter information and then after they
complete the task they have to go in and enter how many they did and check
the complete box.
How do I set up the form so they can see the entries they put in earlier and
go back later and check the complete box and enter how many they processed?
Thanks in advance!!!!
 
LG said:
I have a form that is built and they enter information and then after they
complete the task they have to go in and enter how many they did and check
the complete box.
How do I set up the form so they can see the entries they put in earlier
and
go back later and check the complete box and enter how many they
processed?
Click to expand...


To answer your question, I need to know more about how your form and tables
are set up. It sounds as though you would be well served by a form/subform
arrangement, since the count and check box appear to reside at the task
level, while the records being entered seem to be related to that task. If
you had a main form based on the task, and a continuous subform based on the
related, subordinate table, then it would be easy for the user to see the
records that had been entered. But it's hard to say anything more about it
without more details of what you have and what you are trying to accomplish.

Also, is there really any need to enter the count? That information is
easily calculable and can be automatically displayed in a text box.
 
Let me further explain it is a very simple form for our elder groups that
just do minimal tasks.
The form fields are Date, ID, Batch_Num, check box if completed, and Count.
They go in the morning log the form pops up off the switchboard, and date
and id are autopopulated for them. They enter the batch id number so the
supervisor can look at anytime to see what batch is out. They complete the
batch they go back in and check the completed box and enter the amount they
did. The supervisor at the end of the day takes that total of completed for
their production.
Does that clarify it a little more?
 
LG said:
Let me further explain it is a very simple form for our elder groups that
just do minimal tasks.
The form fields are Date, ID, Batch_Num, check box if completed, and
Count.
They go in the morning log the form pops up off the switchboard, and date
and id are autopopulated for them. They enter the batch id number so the
supervisor can look at anytime to see what batch is out. They complete
the
batch they go back in and check the completed box and enter the amount
they
did. The supervisor at the end of the day takes that total of completed
for
their production.
Does that clarify it a little more?
Click to expand...

Somewhat, but what are the tables involved? Assuming there are two related
tables -- one for the batch and one for the detail items in the batch --
what fields relate the two tables?
 
There is only 1 table this feeds back to. The batch Id is not linked to the
other tables. They manually enter it. I just need them to be able to put
the info in the form and then go back into in a click the box when it is
completed and change the count if necessary.
 
Back
Top