My question is related to opening a form (using a button) that shows a record using entries in unbound combo boxes. I want to be able to open one form ("Checklist") by clicking one button ("Open Checklist button").

What I can't figure out is if/how I can set the onclick() for the button to open IF unbound combo box 1 (where I search for address based on address field in Table1) has a value OR unbound combo box 2 (where I search for address ID based on address ID field in Table1) has a value.

The reason I have to do this is most of the rows in the associated table (Table1) have an address, but not all, so I want to be able to open a form using either the property address OR the property address ID.

Originally, I used a OpenForm Where Condition when I was opening the "Checklist" form using the unbound combo box 1 (address) (="[address ID]=" & "'" & [unbound combo box 1] & "'"); can I update this code to be an "OR" statement (either unbound combo box 1 value OR unbound combo box 2 value?) I tried this idea, but was unable to be successful.