Passing check box value to a query as criteria

[dosia]

Hello, I am just learning access. I need to pass values of my two check boxes on my Form
Check box US and Check Box Canada
if both checked the criteria would be "UD", "ud',"b","B","us","US","CD","cd"
if Canada check box checked criteria would be "cd","CD"
if US only checked criteria would be UD", "ud',"b","B","us","US"

I am not sure how to write the criteria statement on the query?

this probably would be a complicated iff statement? Any help would be appreciated.

Dosia

 

[Mihail]

Hi. Welcome to the forum !

Read this:
Database Normalization and Table Structures - Microsoft Access / VBA
and that check boxes will disappear from your forms.

 

[dosia]

Sorry I have to work with what i have,can't change the Database structure.