Form Checkbox/combobox help

[KevinMCB]

Hey guys,

I am fairly new to access and having a bit of trouble. In my database I have a table with a checkbox option for an inventory audit. (ex. is it there or not?) I have created a good form for it as well. Now I am trying to open the form from the home page with a combo box and a button, the combo box selecting the location of the inventory. Ex. building 1 or building 2.

However, I only want the form to show the inventory with the box unchecked. I am using an append querry to pull the data from a master table into my audit table every month.

Basically I need to the equation form for the macro on the button I am using to open the form. What should the checkbox value equal in the equation etc. ex. =1 if checked =0 if empty or something. Thanks for taking a look at my problem!

[KevinMCB]

Got it figured out. Please disregard this thread.

[RuralGuy]

Care to share your solution with the others that read this Forum? You might also want to use the Thread tool and mark this thread as Solved.

[KevinMCB]

I need to set the checkbox =0 for the form to pull the unchecked records. From there it was just your standard equation for tying the open form button to the combo box. Something like this:

[Table with Audit info from append query]![Located]=0 And [DLR]=[Forms]![Homepage]![Combo box name]

[RuralGuy]

Thanks for posting back with your solution.