Save Data from Previous Record

  • Thread starter Thread starter jlamb
  • Start date Start date
J

jlamb

I have a access database that I input items for inventory. I have
multiple items with the same model and description. I would like to
have a button with an event procedure that would save certain data for
the next record and advance to the next record. I would also like to
have another button to save the current record, clear the form and
advance to the next record.
 
The following KB articles show different methods to reference values from
the previous or other records in a form. To move to the next record, one
alternative is to use the DoCmd.GoToRecord method.

http://support.microsoft.com/default.aspx?scid=kb;en-us;210504
http://support.microsoft.com/default.aspx?scid=kb;en-us;210236

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a access database that I input items for inventory. I have
multiple items with the same model and description. I would like to
have a button with an event procedure that would save certain data for
the next record and advance to the next record. I would also like to
have another button to save the current record, clear the form and
advance to the next record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
saving event 3
Embedded Macros 1
copy previous record 5
Record insert/delete anomaly 0
Getting value from previous record 7
Commit/Save Record 4
Enter Data from a Form into a Table 2

Back
Top