There will likely be more questions as I expand the capabilities of a working database.
I have a Main Form called [Insertion Orders]. On it is a subform (control name subfrmIODetails). There is a text field in subfrmIODetails called txtDetailID.
As way of explanation, there is currently a text field on the first subform that currently holds all the dates of a given detail record. I may want to use the actual dates for calculations later, so I decided to add this additional subform to capture them in a table.
I have added another subform control to the main form called subfrmAirDates. Its underlying table (tblIODetails_Dates) has three fields: Date_ID (primary autonumber); Detail_ID; Air_Date).
I cannot get the two subforms to sync with each other. The Link Master Field is a text field on the main form (txtLinker) whose control source is =[subfrmIODetails].[Form]![txtDetailID]. That txtLinker field properly updates as I scroll through subfrmIODetails. subfrmAirDates does not change as I scroll. The Child Link is txtDetail_ID, a hidden field on the little subform.
I'm sure this is an easy fix, but I am unable to see it. Maybe it's a forest for the trees thing, or maybe it's Friday, or maybe I'm just thick this afternoon.
I'm going to ask another question on this new path when I get this simple problem resolved.
Thanks for all the great advice I continue to get here!
MIB1019
I have a Main Form called [Insertion Orders]. On it is a subform (control name subfrmIODetails). There is a text field in subfrmIODetails called txtDetailID.
As way of explanation, there is currently a text field on the first subform that currently holds all the dates of a given detail record. I may want to use the actual dates for calculations later, so I decided to add this additional subform to capture them in a table.
I have added another subform control to the main form called subfrmAirDates. Its underlying table (tblIODetails_Dates) has three fields: Date_ID (primary autonumber); Detail_ID; Air_Date).
I cannot get the two subforms to sync with each other. The Link Master Field is a text field on the main form (txtLinker) whose control source is =[subfrmIODetails].[Form]![txtDetailID]. That txtLinker field properly updates as I scroll through subfrmIODetails. subfrmAirDates does not change as I scroll. The Child Link is txtDetail_ID, a hidden field on the little subform.
I'm sure this is an easy fix, but I am unable to see it. Maybe it's a forest for the trees thing, or maybe it's Friday, or maybe I'm just thick this afternoon.
I'm going to ask another question on this new path when I get this simple problem resolved.
Thanks for all the great advice I continue to get here!
MIB1019