Checkbox doesn't work when true

[steve1111]

Hello,

I have a query that uses a checkbox from a form as a criteria. in the table the values are stored as 0,-1. if i run the query with the checkbox false, the query works and filters correctly, same if the box is null. But when I check the box true, no records load. It worked in an older version of my database so i am not sure why when i copied it over it doesn't work. I even tried a combo box with values of 0, -1 and got the same results.....

thanks

 

[vbaInet]

Let's see the SQL of the query.

 

[pr2-eugin]

How about showing the code involved?

 

[steve1111]

SELECT DISTINCT dbo_Drivers.Name, dbo_Drivers.isActive, dbo_Drivers.DriverID AS Pin, pvqryZoneAssignments.Division, pvqryZoneAssignments.[Transporation Coordinator], pvqryZoneAssignments.[Transporation Supervisor], dbo_Zones.Note AS [Zone]
FROM (dbo_Drivers INNER JOIN pvqryZoneAssignments ON dbo_Drivers.DefaultZoneID = pvqryZoneAssignments.ZoneID) INNER JOIN dbo_Zones ON pvqryZoneAssignments.ZoneID = dbo_Zones.ID
WHERE (((dbo_Drivers.isActive)=[Forms]![frmMain]![subaAssets].[Form]![snavStaff].[Form]![subnDrivers]![optActive] Or [Forms]![frmMain]![subaAssets].[Form]![snavStaff].[Form]![subnDrivers]![optActive] Is Null));

 

[vbaInet]

Add the parameters in the Parameters list in the query and set them to the appropriate data types.

 

[steve1111]

I actually have 5 optional criteria on that form, but the checkbox is the only one that is not working when true. I have never had to enter anything into a parameter box in the past, so when i add it now, it is giving me an error if i try and add a Or Is Null statement.

 

[vbaInet]

so when i add it now, it is giving me an error if i try and add a Or Is Null statement.

Please be more explicit. What error?