create form with top part showing new record and bottom part of form showing a history

[Lhuffst]

Would like to create a form that has the top part going to a new record for data entry but the bottom half of screen show a history of what that person has already entered. The history part cannot be edited. Any suggestions?
Currently I have a form that has the top part working but, although not a requirement, can see where the folks will want to see what they entered yesterday or even last week.

I envisioned something like.
Data Entry Type : Drop Down list of values
Data Added: Current Date
Number of Sheets: Number text box
=======================================================
History Area
Data Entry Date Added No. Sheets
Warranty 4/13/15 2
FH 4/13/15 22
Warranty 4/12/15 1
Metal Sheets 3/1/14 200

Where the history area would look like the datasheet or a spreadsheet but cannot be changed.

 

[MajP]

Sounds like a standard main form with a subform. What is the question/problem?

 

[Lhuffst]

It's not a problem but really just a thought and since that form is already a subform, I'd like to keep it as one subform (I have other subforms that I will do the same thing with). Is there away to have both of them on one form without another subform? My thought was that when they enter the info on the new record side, it would then automatically update the history side. Wasn't sure if this was feasible or even a good idea. The inspectors can only enter data for that day but the supervisors can enter it for that day and/or any other day. Looking back by clicking the record forward and back works but is cumbersome if you have alot of records.

 

[Lhuffst]

if I use the split form (which is close), then how do I lock out the datasheet area while allow inputs in the top part of the form?

 

[MajP]

Not sure what is on the main form, but you can have multiple subforms on a main form. So in your case the first subform is in single form view and has
Data Entry Type : Drop Down list of values
Data Added: Current Date
Number of Sheets: Number text box

The second subform is the history. A little formatting and it looks like a single form.

 

[Lhuffst]

ok thanks. I'll try that