asked on 3/31/2004

Combo Box for golf tournament database

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)

Microsoft Access

Last Comment

Steve Bink

3/31/2004

AndyAmess

3/31/2004

what is the sql behind your combo box?

Rey Obrero (Capricorn1)

3/31/2004

you can use

Select Hole From tblHoles where tblHoles.Players < 4

ukbusiness

3/31/2004

ASKER

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

Rey Obrero (Capricorn1)

3/31/2004

Try this;

SELECT DISTINCTROW tblStartingHole.* FROM tblStartingHole
WHERE ([tblStartingHole].[PlayersField] < 4)
ORDER BY [tblStartingHole].[StartingHole];

ASKER CERTIFIED SOLUTION

Steve Bink

3/31/2004

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial