I have a form in Access that asks for NCMR(Non-Conformance Material Report) Type. Options are SSP Production and Vendor. I have all information entered into this form being automatically transferred to another form to be printed. On the printable form, The NCMR Type is checkboxes not a drop-down list. How do I get Access to check the box on the printable form when someone picks one of the options from the drop-down list on the input form?
The printable form is a document that cannot be changed without going through a long drawn out process.