Hi all
I ham trying to have some headers with some relivant info across the top I have 3 forms
FrmFullDetails
SFRMStaffDetails
SFRMOfficeDetails
In the form header of Full Details I want a TextBox to show relevant information so when the user scrolls down the page this stays at the top of the page, the information I want to show is from the two Subforms named above but nothing works, the information is just for visual aid only and doesn't need to be editable, I have tried this code for each text box without any success what do I need to change?
I have put the below code in each of the control sources without any real success
I have also tried an update code but the issue is the text wont change when going onto another record
I ham trying to have some headers with some relivant info across the top I have 3 forms
FrmFullDetails
SFRMStaffDetails
SFRMOfficeDetails
In the form header of Full Details I want a TextBox to show relevant information so when the user scrolls down the page this stays at the top of the page, the information I want to show is from the two Subforms named above but nothing works, the information is just for visual aid only and doesn't need to be editable, I have tried this code for each text box without any success what do I need to change?
I have put the below code in each of the control sources without any real success
Code:
=[SFRM_StaffDetails].[Form]![TXBStaffSurname]
=[SFRM_StaffDetails].[Form]![TXBStaffEmployeeID]
=[SFRM_OfficeDetails].[Form]![TXBOfficeID]
I have also tried an update code but the issue is the text wont change when going onto another record