<div>
<br />
what is the sql behind your combo box?
</div>


<div>
you can use <br />
<br />
Select Hole From tblHoles where tblHoles.Players &lt;&nbsp;4<br />

</div>


<div>
SELECT DISTINCTROW tblStartingHole.* FROM tblStartingHole ORDER BY [tblStartingHole].[Startin<wbr />gHole];<br />

</div>


<div>
Try this;<br />
<br />
SELECT DISTINCTROW tblStartingHole.* FROM tblStartingHole <br />
WHERE ([tblStartingHole].[Player<wbr />sField] &lt;&nbsp;4)<br />
ORDER BY [tblStartingHole].[Startin<wbr />gHole];
</div>


<div>
<div class="content wysiwyg-content">
I am running a golf tournament and have set up a database all components are working well. &nbsp;However I would like to add a little enhancement. &nbsp;We have 36 teams with 4 players on each team. &nbsp;Starting Hole table runs a cboStartingHole with a field showing 1A, 1B, 2A, 2B, etc.. &nbsp;When 1 have assigned 4 players (1 team) to a hole I would like that specific hole to not show in the cbo, to prevent accidentally assigning a 5th player (or worse an entire other team)
</div>
</div>


I am running a golf tournament and have set up a database all components are working well.  However I would like to add a little enhancement.  We have 36 teams with 4 players on each team.  Starting Hole table runs a cboStartingHole with a field showing 1A, 1B, 2A, 2B, etc..  When 1 have assigned 4 players (1 team) to a hole I would like that specific hole to not show in the cbo, to prevent accidentally assigning a 5th player (or worse an entire other team)

you can use 

Select Hole From tblHoles where tblHoles.Players &lt; 4


SELECT DISTINCTROW tblStartingHole.* FROM tblStartingHole ORDER BY [tblStartingHole].[StartingHole];


Try this;

SELECT DISTINCTROW tblStartingHole.* FROM tblStartingHole 
WHERE ([tblStartingHole].[PlayersField] &lt; 4)
ORDER BY [tblStartingHole].[StartingHole];

Combo Box for golf tournament database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.