'Save' buttons really goes against the way Access is intended to work and frequently cause more problems than it solves. In Access moving to another Record, closing the Form or closing Access, itself, will save a Record. If you simply have to have a 'save and move to a new Record' button, all it needs to do is move to a new Record.
To 'carry data forward' for some Controls, you can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.
Code:
Private Sub YourControlName_AfterUpdate()
Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub
You’ll need to do this for each Control that you want to ‘carry forward.’
Note that this code/syntax can be used for any Datatype.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Entering form data
Windows 7 
Access 2003
I need to be able to load my form, enter the required data, save the data to my table and then recall the data just saved. I then need to change one or two items and then save to the table as a new entry. My desire is to do this with a button on the form i.e., save button, add new data button, recall button. I need to do this because some of my locations have 1 sub-address while others have several sub-addresses but have 5 of 7 fields with the same data. I don't want to have to retype the same data over and over.
Reply With Quote
