Huge title ...
I have db that tracks machine usage for about 30 machines, all the information is stored in a table (Data). Each day a supervisor will enter downtime hours into 5 categories (downtime 1, downtime 2, etc), i have created a form (Data Entry Form) using an append query with dummy values that allows users to enter data for all 30 machines at once. I also have a fields "Component in Progress" and "Queued Parts" that the user will input text for. What im interested in doing is having the form display the values from the previous record in the "Component in Progress" and "Queued Parts" fields as default. These fields will stay the same for several days until the component is finished. Thanks in advance for your help!
I have db that tracks machine usage for about 30 machines, all the information is stored in a table (Data). Each day a supervisor will enter downtime hours into 5 categories (downtime 1, downtime 2, etc), i have created a form (Data Entry Form) using an append query with dummy values that allows users to enter data for all 30 machines at once. I also have a fields "Component in Progress" and "Queued Parts" that the user will input text for. What im interested in doing is having the form display the values from the previous record in the "Component in Progress" and "Queued Parts" fields as default. These fields will stay the same for several days until the component is finished. Thanks in advance for your help!
Comment