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

Display Results of Last Record Saved in Certain Fields

P: 2
After saving a record using a form, I want certain fields on the data entry form to display the same information from the previous record.
Oct 12 '06 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,221
llucas,
Depends what you mean by "previous." Are you adding a new record, or updating a previously existing record. If you are updating a record, then you can simply
(make sure to check that you're not already at the first record)
rs.MovePrevious or
DoCmd.GoToRecord , , acPrevious

If you added a new record, you have to go to that record before you can go to the record previous to that:
rst.Bookmark = rst.LastModified
then rst.MovePrevious

Hope that helps,
Jim
Oct 14 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
If you want your new record to display the values in certain fields from the previous record. Before saving you can get the values and put them into variables public to the form class module. Then when you go to new record you can pass the values in the variables to the new record.



After saving a record using a form, I want certain fields on the data entry form to display the same information from the previous record.
Oct 14 '06 #3

Post your reply

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