Hello,
I have a form in Access that we input information about a nonconforming part. This form is set up to automatically transfer the data to a printable form. The person who set this up did not set it up to where the checkbox on the printable form automatically gets checked.
In the input form, there is a dropdown for NCMR Type. The two options are "SSP Production" and "Vendor Reject". I need this information to automatically check a checkbox on the printable form. I am new to how Access communicates between forms and tables.
The Input Form and Printable Form Record Source: "NCMR Main Table"
The Drop-down list on Input Form for NCMR Type: Control Source: "N NCMR Type", Row Source: "SELECT DISTINCTROW [NCMR Type Table].[ID], [NCMR Type Table].[NCMR Type] FROM [NCMR Type Table];", Row Source Type: "Table/Query"
Any help would be much appreciated.