Combo Box "WHERE"

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.
 
M

mscertified

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

-Dorian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top