Using a Check Box to pass a value to a query

[nickvans]

I have a question which I'm sure has a simple answer, but I'm pretty new at this.

I have a database which contains several tables including tblModules and tblParts. tblParts stores module numbers attached to part numbers, using the combination of module number and part number as the primary key. The tblModules table has module numbers/location/description.

I have a form which allows the user to input part numbers, which runs a query which results in showing only modules which contain the parts. I would like to create a check box that will include a part number (prt913004) in the query when checked, but will return only modules that do NOT contain the part when unchecked.

Any idea how to do this? All help is appreciated. Thanks!

[cyberdwarf]

Hi Nick

Try something like this for the AfterUpdate event of the Part number field:-

If Me.Chackbox=False Then
    Me.Comboname.ControlSource="SELECT * from tblModules Where PartNumber=" & Me.PartNumber
Else
    Me.Comboname.ControlSource="SELECT * from tblModules Where PartNumber<>" & Me.PartNumber
EndIf
Me.Comboname.Requery

HTH
Steve

[nickvans]

Thanks for the prompt reply Steve!

I like how that code is structured, and its very close to what I was hoping for, however, is there a way to output to a query rather than to a combo box? I have many filters for different parts and descriptions and so on, all of which go to a master query which populates a list box in my form. Can I have the IF statement fill in the criteria in a query?

Thanks again.