Auto Fill Combo Box

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?
 
B

bhicks11 via AccessMonster.com

So you set the bound column to 1 (CompetitionName) but the Control Source to
cboCompNameCompDetails AND >cboPlayingOptionCompDetails. The control source
is the field that the value of the combobox will be save to. How did you set
it to two fields?

Bonnie
http://www.dataplus-svc.com
 
B

Brampton76

Many thanks for replying - I hadn't appreciated the control source link -
that may well explain why it does not work! I assume that I should now
change the Control Source to reflect the Cost? Where would I place a
statement that looks at the Competition Name and the Playing Option before
auto filling the Cost box?
 
Top