Save Data from Previous Record

[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.

 

[David Lloyd]

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.