Not working

[Fie]

Hey... am getting really annoyed now cause it aint woking grrr

Q: To gett the No. Pupils value from the combo box to be able to
do a calculation in another box in my form.. i have to 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)


BUT...... where do i put this code???? i assum its in the box i want
the calculation to apear in but where about??? the calculation i want
to do is to get


possible no. meals = No. Pupils x No. Days



A: In the control source of the field No.meals you write


=[MyComboBox].Column(2) * [No Days TextBox]



BUT........ should it not be put in the control cource of possible no.
meals???? i dunno but it just seems more logical cause thats where i
want the answer to go!!!

anyway iv tried putting it in both boxes control source and it aint
working...

should =[MyComboBox] equal the name of the combo box (which is School
name)???

HELP am SOOOOO LOST

 

[Arvin Meyer [MVP]]

You may need a more explicit reference:

=[Forms]![YourFormName]![MyComboBox].Column(2) * [Forms]![YourFormName]![No
Days TextBox]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Steve Schapel]

Fie,

Yes, you are meant to replace the names used in the examples with the
actual names of your actual controls. If your combobox is called School
Name, and the textbox with the number of days is called No Daze then the
Control Source expression will be like this...

=[School Name].[Column](2)*[No Daze]