B
Brampton76
I have a Competition Entry Form with a number of fields that when complete is
linked to a Competition Entry Table. 3 of the fields in the Entry Form are:
CompetitionName, PlayingOption (ie All Day, Half Day etc) and Cost - all of
these details can be found in a Competition Setup Table (there are 5
different Playing Options for each competition with differing costs). The
competitor is given a Combo Box to select the competition in which to play, a
further Combo Box to select the playing option and I would like to third
Combo Box (the Cost) to auto fill based on the choices of the previous two
boxes. For the Cost Combo Box I have - in the Row Source - SELECT
CompetitionName, PlayingOption, Cost FROM tblCompetitionSetup ORDER BY Cost.
Then I have set the Colums to 3, the Width to 0,0,1 and the Bound Column to
1. I then set the Control Source to =cboCompNameCompDetails AND
cboPlayingOptionCompDetails, thinking that I would get the Cost. I can see
the cost as a drop down list in the Combo Box but the box does not auto fill
with the amount based on a combination of the competition name and the
playing option. I wondered if there was someone who could assist please?
linked to a Competition Entry Table. 3 of the fields in the Entry Form are:
CompetitionName, PlayingOption (ie All Day, Half Day etc) and Cost - all of
these details can be found in a Competition Setup Table (there are 5
different Playing Options for each competition with differing costs). The
competitor is given a Combo Box to select the competition in which to play, a
further Combo Box to select the playing option and I would like to third
Combo Box (the Cost) to auto fill based on the choices of the previous two
boxes. For the Cost Combo Box I have - in the Row Source - SELECT
CompetitionName, PlayingOption, Cost FROM tblCompetitionSetup ORDER BY Cost.
Then I have set the Colums to 3, the Width to 0,0,1 and the Bound Column to
1. I then set the Control Source to =cboCompNameCompDetails AND
cboPlayingOptionCompDetails, thinking that I would get the Cost. I can see
the cost as a drop down list in the Combo Box but the box does not auto fill
with the amount based on a combination of the competition name and the
playing option. I wondered if there was someone who could assist please?