Form for portion of record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a form for entering data to store a Bill of Materials for
making an item. (For simplicity sake, I am entering a PartNumber, Component,
and Quantity.)This works fine except for when the data entry is interrupted.
It is very difficult to find where I left off and which line of the bill is
next to be entered.

What I would like to do is to enter the PartNumber, then move into an area
on the form that will allow me to enter the details of the bill for that part
by entering a series of Components and Quantities. This area would display
the last several (3 to 5) lines that have been entered, so that it would be
easy to see what has been entered and what has not. This area would scroll
if the bill is longer than 3 to 5 lines.

As each line of this area is completed, the entire record could be saved,
but the PartNumber that was entered earlier would need to be added to each
line to complete the table.

Can something like this be done? Any direction/suggestion would be
appreciated.

Thanks.
 
I currently have a form for entering data to store a Bill of Materials for
making an item. (For simplicity sake, I am entering a PartNumber, Component,
and Quantity.)This works fine except for when the data entry is interrupted.
It is very difficult to find where I left off and which line of the bill is
next to be entered.

What I would like to do is to enter the PartNumber, then move into an area
on the form that will allow me to enter the details of the bill for that part
by entering a series of Components and Quantities. This area would display
the last several (3 to 5) lines that have been entered, so that it would be
easy to see what has been entered and what has not. This area would scroll
if the bill is longer than 3 to 5 lines.

As each line of this area is completed, the entire record could be saved,
but the PartNumber that was entered earlier would need to be added to each
line to complete the table.

Can something like this be done? Any direction/suggestion would be
appreciated.
Click to expand...

A Form with a continuous Subform does exactly and precisely what you
suggest.

John W. Vinson[MVP]
 
Back
Top