Combo Box "WHERE"

  • Thread starter Thread starter nybaseball22
  • Start date Start date
N

nybaseball22

Is there a way I can change a regular code for a combo box (as seen
below) to only select items where something is true?

SELECT TrainDelivery.[Delivery] FROM TrainDelivery ORDER BY
[Delivery];

I want to only have the items show up if they are active, designanted
by a check in a check box in the same table.

Thank you.
 
SELECT TrainDelivery.[Delivery] FROM TrainDelivery WHERE [MyCheckbox] = True
ORDER BY [Delivery];

-Dorian
 
Back
Top