Hi,
So this is a two part question.
I have this main form "Manufactur ing Production Log" and a sub form "Equipment Downtime Log". Each record on the subform is going under a field in the main form called "Part Number". At least that's what I'm trying to do. The "Part Number" needs to be pulled from the main form and displayed in a corresponding text box on the sub form, anytime a new record is made on the subform. I tried putting this expression as the control source:
=[Forms]![Manufacturing Production Log Form].[Form]![Part Number]
However, it doesn't actually save the record in the subform's table. Anyway I can do this properly?
Second question
I have calculated fields on the subform that need to pull from fields on the main form. I once again tried putting expressions in their control sources but the records don't save in the subform's table.
Here's an example:
Parts Lost to Downtime: =(-[Equipment Downtime (MIN)]/60)*[Goal OPLH] (from main form)*[Headcount Used] (from main form)
This is the expression I put in the field's control source:
Parts Lost to Downtime: =(-[Equipment Downtime (MIN)]/60)*([Forms]![Manufacturing Production Log Form]![Goal OPLH])*([Forms]![Manufacturing Production Log Form]![Headcount Used])
It works but it doesn't save the record onto the table.
How should I go about this?
Disclaimer: I am new to Access and have been watching YouTube videos to get this database working. Please explain like I'm 5.
So this is a two part question.
I have this main form "Manufactur ing Production Log" and a sub form "Equipment Downtime Log". Each record on the subform is going under a field in the main form called "Part Number". At least that's what I'm trying to do. The "Part Number" needs to be pulled from the main form and displayed in a corresponding text box on the sub form, anytime a new record is made on the subform. I tried putting this expression as the control source:
=[Forms]![Manufacturing Production Log Form].[Form]![Part Number]
However, it doesn't actually save the record in the subform's table. Anyway I can do this properly?
Second question
I have calculated fields on the subform that need to pull from fields on the main form. I once again tried putting expressions in their control sources but the records don't save in the subform's table.
Here's an example:
Parts Lost to Downtime: =(-[Equipment Downtime (MIN)]/60)*[Goal OPLH] (from main form)*[Headcount Used] (from main form)
This is the expression I put in the field's control source:
Parts Lost to Downtime: =(-[Equipment Downtime (MIN)]/60)*([Forms]![Manufacturing Production Log Form]![Goal OPLH])*([Forms]![Manufacturing Production Log Form]![Headcount Used])
It works but it doesn't save the record onto the table.
How should I go about this?
Disclaimer: I am new to Access and have been watching YouTube videos to get this database working. Please explain like I'm 5.