new at this

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kevin carter - 07 Apr 2004 10:21 GMT

hi
can you please help me
i am new at using access
i have created a form that accepts user input for components
what i want is to have the user select a component from a list and on doing
so the price for the component is displayed on the form.
when the user enters the quantity the total price is displayed on the form
how do i get the total price to calculate on the condition that both the
component and price fields are not empty?

thanks in adavnce

kevin

Reply to this Message

Jeff Boyce - 09 Apr 2004 13:18 GMT

Kevin

Actually, I suspect you'll want to be able to have the total price
recalculated when 1) the component is changed or 2) the quantity is
changed, AND both fields have an entry.

One approach would be to write a general procedure as "code behind form" --
this procedure would recalculate and fill the total field, based on the
contents. In each of the two other fields' (quantity, component)
AfterUpdate events, you'd "Call" that general routine.

Signature

Good luck

Jeff Boyce
<Access MVP

Reply to this Message

kev carter - 14 Apr 2004 20:33 GMT

thanks i will try now

> Kevin
>
[quoted text clipped - 6 lines]
> contents. In each of the two other fields' (quantity, component)
> AfterUpdate events, you'd "Call" that general routine.

Reply to this Message