Currently I have a main form and 5 sub forms. I have a drop
down on the main form that selects a partnumber. This then
populates certain fields on the subforms from a table/query. I also
have 3 unbound fields on each of the subforms. These unbound
fields are for inputting data that corresponds with the
fields that are populated fromt the table/query. The 3 unbound
fields are:
ReplenishMethod
ReplenishTime
ReplenishSignal
After these three fields have data inserted into them the
information from those 3 fields plus several other already
populated fields are sent to a new table from AfterUpdate
Event from ReplenishSignal field. That all works just great.
My issue is the next time I select the same partnumber from
the main form I would like to be able to see the information
that was inputted into the 3 unbound fields the 1st time
ReplenishMethod
ReplenishTime
ReplenishSignal
fields. As I stated above these 3 fields are
unbound. The information is in the new table where they
were sent to. How can I obtain the information to
populate these 3 unbound fields if they have already been populated
before. Do I need to change my way of thinking here?
SUMMARY:
I have 3 fields on a subform that do not have information in them from
the table/query. I manually populate these 3 fields and
then add the records to another table. If I then come back
to the same partnumber at another time and I have already
manually input these 3 fields I would like to see that but I
do not know how to accomplish this.
Any thoughts,suggestions etc.?
down on the main form that selects a partnumber. This then
populates certain fields on the subforms from a table/query. I also
have 3 unbound fields on each of the subforms. These unbound
fields are for inputting data that corresponds with the
fields that are populated fromt the table/query. The 3 unbound
fields are:
ReplenishMethod
ReplenishTime
ReplenishSignal
After these three fields have data inserted into them the
information from those 3 fields plus several other already
populated fields are sent to a new table from AfterUpdate
Event from ReplenishSignal field. That all works just great.
My issue is the next time I select the same partnumber from
the main form I would like to be able to see the information
that was inputted into the 3 unbound fields the 1st time
ReplenishMethod
ReplenishTime
ReplenishSignal
fields. As I stated above these 3 fields are
unbound. The information is in the new table where they
were sent to. How can I obtain the information to
populate these 3 unbound fields if they have already been populated
before. Do I need to change my way of thinking here?
SUMMARY:
I have 3 fields on a subform that do not have information in them from
the table/query. I manually populate these 3 fields and
then add the records to another table. If I then come back
to the same partnumber at another time and I have already
manually input these 3 fields I would like to see that but I
do not know how to accomplish this.
Any thoughts,suggestions etc.?
