Hi, just wondering if anyone can help. I am so glad I acciddently stumbled into this forum.Since my knowledge on Access is basic to moderate and have taught myself most of what I know, this forum is very useful.
I have created a form based on a table and part of the fields in this form are entered by someone and other fields are filled based on a query. This is my scenario:
One of my operators opens a form, selects a part number, clicks on continue, this opens a second form for entering data and stores the selection from the first form. ( I choose not to use the subform feature) The operator can now add information such as date, operator number and quantity of parts produced.
Operators enter their quantity produced in a combobox field labelled # 1. They tab to the next Combobox field labelled # 2 which runs a query giving the yearly total plus the quantity just entered in the field #1.
What I cannot do is store that value into my underlying table.
I need to know this value before the dies are sent to another department inwhich those operators then update the table to show that the quantity has been set back to zero.
I know that storing calculated values are a bad thing, but my boss has asked me to store this information so that we can run reports for all the dies based on a previous date and know how many parts these dies have produced at any given time. Can anyone help. Please. I know there is a way, I just can't figure it out. I appreciate any help. Thanks Sandra
I have created a form based on a table and part of the fields in this form are entered by someone and other fields are filled based on a query. This is my scenario:
One of my operators opens a form, selects a part number, clicks on continue, this opens a second form for entering data and stores the selection from the first form. ( I choose not to use the subform feature) The operator can now add information such as date, operator number and quantity of parts produced.
Operators enter their quantity produced in a combobox field labelled # 1. They tab to the next Combobox field labelled # 2 which runs a query giving the yearly total plus the quantity just entered in the field #1.
What I cannot do is store that value into my underlying table.
I need to know this value before the dies are sent to another department inwhich those operators then update the table to show that the quantity has been set back to zero.
I know that storing calculated values are a bad thing, but my boss has asked me to store this information so that we can run reports for all the dies based on a previous date and know how many parts these dies have produced at any given time. Can anyone help. Please. I know there is a way, I just can't figure it out. I appreciate any help. Thanks Sandra