Limit Drop Down List

[PPCO]

I see alot of posts on here about limiting lists but not seeing quite what I
need to do. Wanting to limit a combo box drop down list on a form to whether
a checkbox in the underlying table is checked. Only want entries with the
checkbox checked to show. Thanks!

 

[PPCO]

Ok, so I figured out how to limit the list. I put a where clause in the row
source property. Now it's making my list unalphabetical--need some sort of
order by clause? Thanks!

 

[Wayne-I-M]

Hi

Best to use the wizard if you're not sure how to go about this.

Open you form in Design view
Select View
Select ToolBox
Select ComboBox
Click somewhere on the form where you want the combo to go

In the combo wizard
Select - I want the combo to look up values in a table
Select Next
Select your table
Select the fields you want - includeing the tickbox
Select Next
Select Finish

Save (it wont work yet)

Click the combo
In the properties box (for the combo) select Data column
Select the Row Source row
Click the build option (...) - this open a query
In the criteria row of the Tickbox column put -1
Save
Close query
Do you want to save etc etc etc - select yes.
Save the form

Give it a go and see if it's what you want

 

[PPCO]

Never mind, found where to put it alphabetically

 

[Wayne-I-M]

to sort to the records - one method

Sort the query you have based the combo on