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.
 
Back
Top