Using Forms and Sub Forms

[Guest]

I have created a database to monitor inventory levels between locations of
stores. On the main form users input date, location and quantity where the
inventory is originating. On the sub form the same date, location and
quantity fields are used. The sub form moves the inventory to a new location.

My issue is when you scroll through the records on the main form to view the
data that has been entered in both forms, all fields but the sub form
location are visible. How do I change the form to view all of the data that
has been entered so corrections can be made if necessary?

I have a table to hold the transactions of movement.
I have a table to hold the locations of stores.

 

[Guest]

The field that does not display is a field that was filled on the subform
from a location item chosen from a combo box.