By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Default Values from previous record in table on form with multiple enteries

P: 9
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!
Mar 24 '08 #1
Share this Question
Share on Google+
1 Reply


P: 9
Nevermind, I figured it out using an update query!
Mar 27 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.