Displaying values & calculations using values from Combo boxes

[Fie]

Hi,


Was wondering if anyone could help me and clueless....!!!

I have designed a database that deals with information that is given
from Schools to the local authority.

I would like for the user of the database to be able to select a school
from the schools listed in the a combo box of a form.

Each school has a certain No. of pupils and an uniquie cost code which
i want my form to display once a school has been selected (so that the
user does not need to know the cost code or the number of pupils at the
school as this details will never change). I thought about adding these
in to the combo box aside the school names. But i dont know how to set
headings on the comb box so that the user knows what the values are
that are displayed in the combo box!! Or is there any better way of
doing this.. like look up tables or something am not to sure how to do
very much in access.. :-((

After this, i then need to used the No. of pupils figure to do a simple
calcualtion. I dont know how to get the value from the combo box do do
this calculation which will take place in another field in the form..!!

Please help...

Thanks

Fiona

anyother suggestions would be fantastic..

 

[Allen Browne]

Set the Column Widths property of the column so the extra columns are
zero-width. The user will never see them.

 

[Fie]

ok...

so how do i get the No. Pupils value from the combo box to be able to
do a calculation in another box in my form..????


fie

 

[Fie]

ok...

so how do i get the No. Pupils value from the combo box to be able to
do a calculation in another box in my form..????


fie

 

[Douglas J Steele]

You refer to the combo box's Column property. If the No. Pupils value is in
the 3rd column, you'd use:

Me.MyComboBox.Column(2)

(column numbers start at 0 for the Column property)