Help finding easy solution to adding to previous records

[Mwhiterabbbit]

Hello,



I have tried searching but did not find anything that was helpful to me. I work for a bakery that is currently using a lot of paper for some tasks and Access for others. The less paper we have to deal with the better it is for all of us so I am trying to move one part of our job into Access to show it can be done and then eventually move the rest. The problem I am having is I cannot find an elegant solution to adding data to a previous record.

Our process currently is we measure our raw cookie dough pucks and record them on one sheet of paper. Then after we bake the cookies we record their measurements onto another sheet of paper. So I am trying to have the form set up to measure our raw dough then eventually come back to the same records and add the baked measurements.

I would like to have some type of simple form that has fields for entering in the raw and baked measurements. Then each measurement would be tied together by their batch number, sku, and date. This way the batch can easily be found in case of audit or customer complaint.

Is there a known example that I can use to get started or some tips?

[June7]

Build a form bound to the table. Search the form to find the desired record. Use Access intrinsic search and sort tools or write code for custom procedures.

Here is example using parameterized query http://datapigtechnologies.com/flash...tomfilter.html

Other methods will involve more code. How much depends on how complex a search you want to do. http://allenbrowne.com/ser-62.html

[Mwhiterabbbit]

Thanks that should be enough to get me started