new at this

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

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
 
Hi kevin

Since no-one esle has replied, here is my 2c worth.

- You can get Access to perform calculations by using the ControlSource
property of the control in which you want the calculated value to appear.
Say your form has three textboxes named txtOne, txtTwo and txtThree. If you
put the following entry into the ControlSource property of txtThree, this
would automatically calculate the product of the other two boxes, and
recalculate that value whenever the other two boxes changed:

=txtOne * txtTwo

- For basic information on how to set up forms, you would be best to get a
book on learning Access. These forums necessarily assume a basic level of
understanding on how to create a form etc. This is possibly why no-one
answered you initially. You're always more likely to get answers to specific
questions, eg. "how do I get one textbox to show the product of the values
in two other textbixes?".

- You'll get better help if you use a meaningful subject line on your posts.
Maybe "Calculating in forms?", not "new at this" :-)

Hope this helps,
TC
 
Back
Top