Form populating two records in the same table?

[jbaughman]

I may be going about this in completely the wrong way, but I'll try to explain what I'm trying to accomplish.

I have a table - RollTable

I am tracking footage of usage on a roll of paper for printing. I would like to have a form where the operator would only have to put in the beginning information of the new roll, and the form would copy that information as the ending information of the previous roll. So, basically, I want to use the information from the form to populate different fields in different records in the same table.

I think I can do it with a split form, however, I'm just not sure that I would be using the best method to accomplish what I am needing.

Any help would be great!!

Thanks in advance,
Jeff B

 

[jbaughman]

Solved! I figured it out.

The press will only ever have 1 Roll of paper active at any time, so I created a query to pull the record that is missing the ending data.
I then created a subform based on that query on the change roll form.
I created an unbound text box with 'on change' and 'after update' events that feeds it's data into the BegFootage of the new roll and also populates the subform field EndFootage.
I then did the same thing with a combo box that populates the BegRollOperator and the subform field EndRollOperator.

I also hid all the unnecessary stuff from the operators.

Here's an image of my design view (all items in red are hidden):