Hello all,
I need help with my form. I have a table called "Download_Log", where data received is logged into this table and assigned an identifier called "File_ID."
Once this file is QC'd, the user will go to a form called "Data_QC_Form", select the File_ID from a combo box based on a query that pulls all unique file ID's from the table "Download_Log", then enter data regarding the QC. There's some shared fields on this form (and underlying table) that I would want to automatically populate based on the file_id that the user selects from the combo box.
I have done this before but it has been soooo long ago, that I forgot how I did it, and I'm working with the most recent version of access, where as way back then I was working with 2003 access, so here I am asking for assistance and guidance.
Thank you for your time!:banghead:
I need help with my form. I have a table called "Download_Log", where data received is logged into this table and assigned an identifier called "File_ID."
Once this file is QC'd, the user will go to a form called "Data_QC_Form", select the File_ID from a combo box based on a query that pulls all unique file ID's from the table "Download_Log", then enter data regarding the QC. There's some shared fields on this form (and underlying table) that I would want to automatically populate based on the file_id that the user selects from the combo box.
I have done this before but it has been soooo long ago, that I forgot how I did it, and I'm working with the most recent version of access, where as way back then I was working with 2003 access, so here I am asking for assistance and guidance.
Thank you for your time!:banghead: