Row Source for Combo Box

  • Thread starter Thread starter dhstein
  • Start date Start date
D

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.
 
Try this --
SELECT [tblCategories].[ID], [tblCategories].[Category],
[tblCategories].[FirstEntry] FROM [tblCategories] WHERE [tblCategories].[ID]
<20;
 
Thanks Karl - that worked.



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

--
Build a little, test a little.


dhstein said:
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.
Click to expand...
Click to expand...
 
Back
Top