Values

[Fie]

Hey...


Finally i have got values from my combo box to display in text boxes on
my form.. but how can i get these values in to my table from the text
box..
text's boxes are called

No. Pupils
Cost Center
Poss No Meals
% Uptake

 

[Jeff Boyce]

If your combo box has the information, you don't need to re-save it into
your table via the text boxes.

Please describe your data a bit more...

 

[Fie]

right.... i have a combo box with 3 columns and 55 rows in it...

1. School Name
2. No Pupils
3. Cost Centre

when u select a school name it then displays the school name in the
combo box,
and no. pupils a no. pupils text box and cost centre in cost centre
text. The No. pupils value is used to do a simple calculation alonge
with the figure the user enters in the no.meals text box. This gives
you poss. no meals which is displayed in the poss. no meals text box ..
then this figure is then used along with the the no.meals to calculate
the % uptake which is displayed in hte % uptake text field.... but
these figures

1. % uptake
2. No pupils
3. Cost Centre
4. Poss No meals are not being saved in to the table... ???? y??
and how do u do this...??

 

[Jeff Boyce]

It sounds like you are doing calculations on the values you already have via
your combo box. In Access, it is rarely necessary to save calculated values
(and there are very good reasons not to).

Instead, consider creating a query that does the calculations 'on the fly'
for you. You can use that query for your forms and reports.

 

[Fie]

Yeah i know that... but the only value in my combo box that is stored
in the tables
is School Name which is in the 1st column of the combo box....

 

[Jeff Boyce]

I may be missing something, but I thought that your earlier post mentioned
"No Pupils" and "Cost Centre" as values returned by the combo box, and
therefore, already available. And that your calculation involved using
these values...

 

[Chris]

yeah u are correct in saying that... but as i said... the only value
from
the combo box that is stored is the School name.. y is this?

 

[Jeff Boyce]

If the combo box can find/display the three fields, the three fields are
already stored somewhere in a table, right? If that's the case, you don't
need or want to store the values again.

Create a query to calculate what you need to, based on the values where they
already exist, not on a copy of them stored someplace else.