Row Source for Combo Box

[dhstein]

I want to modify the row source for a combo box to limit the inputs

This is what I have right now:


SELECT [tblCategories].[ID], [tblCategories].[Category],
[tblCategories].[FirstEntry] FROM [tblCategories];

I want to only allow values where the ID is less than 20.

How would I change that SQL statement? Thanks for any help on this.

 

[KARL DEWEY]

Try this --
SELECT [tblCategories].[ID], [tblCategories].[Category],
[tblCategories].[FirstEntry] FROM [tblCategories] WHERE [tblCategories].[ID]
<20;

 

[dhstein]

Thanks Karl - that worked.

Try this --
SELECT [tblCategories].[ID], [tblCategories].[Category],
[tblCategories].[FirstEntry] FROM [tblCategories] WHERE [tblCategories].[ID]
<20;

--
Build a little, test a little.

I want to modify the row source for a combo box to limit the inputs

This is what I have right now:


SELECT [tblCategories].[ID], [tblCategories].[Category],
[tblCategories].[FirstEntry] FROM [tblCategories];

I want to only allow values where the ID is less than 20.

How would I change that SQL statement? Thanks for any help on this.