selection combo box

[awake2424]

I have a table of (Reagents), that has a check box In Use. How do I create a field on a form that only allows a user to select the "In Use"? Thank you.

 

[catalin.petrut]

If you want a combobox in witch you will have only "in use" reagents, you need to create a query to use as a source for your combo.

 

[awake2424]

I am not sure how to correctly do this, can you please post an example. Thanks.

 

[catalin.petrut]

Use the query wizard: you will need to use fields Reagent (name/id) and the yes/no. On this second column on the criteria you will define the criteria you want. Then, on the combobox wizard, use the query as source.