Good Morning Everyone,
Hopefully this will be quick, I am trying to tweak an existing form for a colleague
Mainform :Frm_booking_In
Subform : Frm_Booking_In_Detail
Subform : Frm_Booking_In_Contracts
Frm_Booking_In_Detail contains Serial Numbers [Serial No] (short text),
Frm_Booking_In_Contracts contains Serial Numbers [ContractSN] (short text) and contracts
I created a textbox on the mainform "Txt_SN" = =[Frm_Booking_In_Detail].[Form]![Serial No] to display the current Serial Number on the Selected
Then in Frm_Booking_In_Contracts i am typing link master as Txt_SN and Child [ContractSN]
The moment i do this and return to the form the Frm_Booking_In_Contracts is blank, Txt_SN is displaying the selected lines serial number but there is 0 records in the contracts subform.
I am sure in the past this method worked with text fields
There are definitely related records, matching exactly
tried creating a new form from scratch just in case but have the same result
If I remove the master/child from the contracts form properties and return to form view it fully displays the unfiltered records from its source query
Maybe I have forgotten something quite simple but I have even opened my own database to reference working examples of this method so I'm at a bit of a loss
Thanks in advance everyone
Hopefully this will be quick, I am trying to tweak an existing form for a colleague
Mainform :Frm_booking_In
Subform : Frm_Booking_In_Detail
Subform : Frm_Booking_In_Contracts
Frm_Booking_In_Detail contains Serial Numbers [Serial No] (short text),
Frm_Booking_In_Contracts contains Serial Numbers [ContractSN] (short text) and contracts
I created a textbox on the mainform "Txt_SN" = =[Frm_Booking_In_Detail].[Form]![Serial No] to display the current Serial Number on the Selected
Then in Frm_Booking_In_Contracts i am typing link master as Txt_SN and Child [ContractSN]
The moment i do this and return to the form the Frm_Booking_In_Contracts is blank, Txt_SN is displaying the selected lines serial number but there is 0 records in the contracts subform.
I am sure in the past this method worked with text fields
There are definitely related records, matching exactly
tried creating a new form from scratch just in case but have the same result
If I remove the master/child from the contracts form properties and return to form view it fully displays the unfiltered records from its source query
Maybe I have forgotten something quite simple but I have even opened my own database to reference working examples of this method so I'm at a bit of a loss
Thanks in advance everyone
Last edited: