Drop-Down List and Checkbox

[steveo0707]

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.

[Welshgasman]

Use an Iif() function expression for each and test for correct value would be one way. Or put same test in query source for report.

[steveo0707]

Hello Welshgasman,

That worked perfectly! Thank you!