Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Saving data using forms 1
- Thread starter mje397
- Start date
-
1
- #2
I believe the following may assist you.
You could also have a command button named SAVE where you would put this code in the Click event property.
As you go from one record to the next, Access automatically saves the previous record.
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106
You could also have a command button named SAVE where you would put this code in the Click event property.
As you go from one record to the next, Access automatically saves the previous record.
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106
SilentAiche
Technical User
As MPH1 said, when you go from one record to the next (or previous), Access automatically saves the record you were working on.
If, however, you really need to save the record before moving to a new blank record, simply click anywhere in the vertical bar that runs up the left side of your form (this is the bar that contains a black triangle "pointing" at the form when you are viewing a saved record, or a symbol that looks like a pencil when you are editing a record). If the "pencil" is showing and you click on that bar, the pencil turns into the triangle and the record is saved without leaving the record.
...Sigh, that's got to be the suckiest explanation ever typed - if it really doesn't make sense, I'll be glad to try again.
Good luck!
Tim
If, however, you really need to save the record before moving to a new blank record, simply click anywhere in the vertical bar that runs up the left side of your form (this is the bar that contains a black triangle "pointing" at the form when you are viewing a saved record, or a symbol that looks like a pencil when you are editing a record). If the "pencil" is showing and you click on that bar, the pencil turns into the triangle and the record is saved without leaving the record.
...Sigh, that's got to be the suckiest explanation ever typed - if it really doesn't make sense, I'll be glad to try again.
Good luck!
Tim
Tim,
That is a good point. I just learned something new. I always turn off the Record Selector, consequently, have never had it appear to even try.
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106
That is a good point. I just learned something new. I always turn off the Record Selector, consequently, have never had it appear to even try.
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106
- Thread starter
- #5
thnx mph1,, I added a command button .. made it easier..
But when I press enter,, it is not going to the next field.I am forced to press TAB for moving to the next record..
Is there anything that I can do so that when I press enter it goes to the next step..
Thnx in advance
But when I press enter,, it is not going to the next field.I am forced to press TAB for moving to the next record..
Is there anything that I can do so that when I press enter it goes to the next step..
Thnx in advance
- Status
Similar threads
