If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default 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? |
#2
|
|||
|
|||
Default Values
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 "Tee See" wrote in message .. . 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? |
#3
|
|||
|
|||
Default Values
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. "Jeff Boyce" wrote in message ... 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 "Tee See" wrote in message .. . 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? |
#4
|
|||
|
|||
Default Values
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 "Tee See" wrote in message .. . 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. "Jeff Boyce" wrote in message ... 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 "Tee See" wrote in message .. . 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
setting default values based on another control value | Barry | Using Forms | 2 | February 3rd, 2006 08:23 PM |
Histogram - Excel doesn't accept my bin values, uses default | GroovySpreadsheetGuy | General Discussion | 0 | November 29th, 2005 04:59 PM |
default values in queries | Jeff B | Running & Setting Up Queries | 11 | March 3rd, 2005 12:49 AM |
default values | Glenn Causey | New Users | 3 | July 19th, 2004 12:21 PM |
Default placement for data values in Charts | Ellen | Powerpoint | 2 | July 14th, 2004 03:56 PM |