Hello,
I have a form and a subform which has a textbox called tctManagerDiary, when I click on a button to hide the subform then click on a button to show the subform the data will not append to the textbox. The code I am trying is
I have also tried other variations like
I have also tried refreshing and requerying the form, but no joy.
Please can anyone suggest what I am doing wrong and how I can correct this.
Thank you,
Malcolm
I have a form and a subform which has a textbox called tctManagerDiary, when I click on a button to hide the subform then click on a button to show the subform the data will not append to the textbox. The code I am trying is
Code:
Me!subfrmDiary.Form.txtManagerDiary = DLookup("ManagerDiary", "tbl_Net_Diary", "TheDate = #" & Forms!frmBackground.txtLocalSystemDate & "#")
I have also tried other variations like
Code:
Forms.frmBackground.subfrmDiary.Form.txtManagerDiary = DLookup("ManagerDiary", "tbl_Net_Diary", "TheDate = #" & Forms!frmBackground.txtLocalSystemDate & "#")
Forms!frmBackground!subfrmDiary.Form.txtManagerDiary = DLookup("ManagerDiary", "tbl_Net_Diary", "TheDate = #" & Forms!frmBackground.txtLocalSystemDate & "#")
Forms.frmBackground.subfrmDiarytxtManagerDiary = DLookup("ManagerDiary", "tbl_Net_Diary", "TheDate = #" & Forms!frmBackground.txtLocalSystemDate & "#")
Forms!frmBackground!subfrmDiary.txtManagerDiary = DLookup("ManagerDiary", "tbl_Net_Diary", "TheDate = #" & Forms!frmBackground.txtLocalSystemDate & "#")
I have also tried refreshing and requerying the form, but no joy.
Please can anyone suggest what I am doing wrong and how I can correct this.
Thank you,
Malcolm