 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / February 2006Default Values
When inputing data thru a form to a table I have a button which closes the form and which I wish to keep as that. How can I keep the last entry in the form as the default when I reopen the form? Are you saying you want the last record entered to be displayed on the form, or that you want the values recorded for the last record entered to be the (new) default values for the next record to be entered? Regards Jeff Boyce Microsoft Office/Access MVP > When inputing data thru a form to a table I have a button which closes the > form and which I wish to keep as that. How can I keep the last entry in > the form as the default when I reopen the form? Jeff Thanks for the response. My simple mind is having a problem understanding the difference between the two options you have given. Are they not the same thing. If I had to choose one it would be the latter. Thanks again. > Are you saying you want the last record entered to be displayed on the > form, or that you want the values recorded for the last record entered to [quoted text clipped - 8 lines] >> the form and which I wish to keep as that. How can I keep the last entry >> in the form as the default when I reopen the form? If your form is a data entry-only form, setting the DefaultValue of the various controls before you leave the form means you'll have these (new) default values when you next open the form (for data entry). If your form is bound to the data in the underlying table, and is NOT only for data entry, you could decide you wanted the form to open pointed at the first record in the table, the last record in the table, or the record that was entered on 1/2/2006 (provided your table includes a DateEntered field). The former reduces the number of keystrokes needed to enter a new record (but only if new records are essentially identical to old records -- and this is a BAD IDEA in a well normalized database design). The latter lets the user see where s/he left off. Regards Jeff Boyce Microsoft Office/Access MVP > Jeff Thanks for the response. > My simple mind is having a problem understanding the difference between [quoted text clipped - 12 lines] >>> the form and which I wish to keep as that. How can I keep the last entry >>> in the form as the default when I reopen the form? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.