inputting values to fields...sorta

[timeh]

Ok, here's the problem:

What i've got is a database which stores contract details .
On one form, I have the following fields,

joining fee - (entered by user)
annual fee - (entered by user)
additional fees -
total fees due - (sum of above 3 fields)

Now, the three 'fee' fields are added to get the "total fees due" field.
This works fine

However, additional fees are calculated depending on the number of "extras" a client has. there are 2 types of extra, "normal" and "high rate". What i would like is to be able to click a button, then choose either a "normal" or "high rate" extra to add. For example, if the user clicked on "normal", i would like £10 to be automatically added to the "additional fees field"
now, i have a table with 2 fields,
"normal" and "high rate"
in the "normal" field i've entered £10
in the "high rate" field i've entered £15

If anyone can tell me how to get be able to allow the user to select "normal" or "high rate" from a list on the "fees" form and automatically add the relevant money to the "additional fees" field i wud be very, very grateful. Or if you think any other method would be better please suggest it

Sorry - this is a really simple problem with 2 big paragraphs, i'm not very good at describing what i need.

keep sayin this but i'm a beginner...hmm don't seem to be movin on much do i hehe

 

[RV]

Use this expression as your row source control element for your forms textbox "total fees due":

=[Forms]![Fees]![joiningfee]+[Forms]![Fees]![annualfee]+[Forms]![Fees]![additionalfee].[Column](1)

Change:

- Fees to the name of your form
- joiningfee, annualfee to the names of
your textboxes,
- additionalfee to the name of your
listbox
- the number in the part [Column](1) to the number of your dependent column (see below).
Numbering of columns start with 0 (zero)

You can add the listbox for "additional fees" in the design grid of your form.
Base your listbox on your rates table (better, create a query which retrieves all your rows from your rates table).

Change these properties of the listbox:

1) in the format tab, set the column width of the column containing the rate amount to 0 (zero width)
2) in the data tab, see to it that your dependent column is the column containing your rate amount

HTH,

RV