I have 3 tables all linked by a key field call Report_ID
I have a form called Reports_tabled (top level)
This form has 2 sub forms – frm_Recommendations (2nd level) and frm_Agency (3rd level)
A completed list of recommendation (long text) for each report is entered into the sub frm_Recommendation (linked by Report_ID) and identified by REC_No (number)
Various agencies in sub frm_Agency may be assigned any of the recommendation in frm_Recommendation. For example agency A1 –may be assigned REC_No 1, 3 and 5 where A2 may be assigned Rec_no 1 and 8
I am trying to auto populate the recommendation (from frm_Recommendation) into the Agency form when a REC_No is entered in this form that has the same value as the REC_No in the frm_Recommendation. (and the report ID links across all 3 forms matches)
I have tried using a lookup box but it dose not support long text values in the wizards.
Any help greatly appreciated
I have a form called Reports_tabled (top level)
This form has 2 sub forms – frm_Recommendations (2nd level) and frm_Agency (3rd level)
A completed list of recommendation (long text) for each report is entered into the sub frm_Recommendation (linked by Report_ID) and identified by REC_No (number)
Various agencies in sub frm_Agency may be assigned any of the recommendation in frm_Recommendation. For example agency A1 –may be assigned REC_No 1, 3 and 5 where A2 may be assigned Rec_no 1 and 8
I am trying to auto populate the recommendation (from frm_Recommendation) into the Agency form when a REC_No is entered in this form that has the same value as the REC_No in the frm_Recommendation. (and the report ID links across all 3 forms matches)
I have tried using a lookup box but it dose not support long text values in the wizards.
Any help greatly appreciated