Text Box not in curreny format

[Guest]

I have two syncronized drop boxes, one where you select the product type (ie
hard drive or motherboard), and another where you select the actual product
(ie 120BG or Asus), and when you select the actual product i want it to
display the price of it. the price and product name are on the same table
and query i made. right now i have it showing up in a text box but its not in
currency form. i also want a subtotal, tax, and grand total at the bottom of
the page for all the items together. and while we're at it i need help on
how to subtract from the in stock column of my table by putting in a number
in the quantity text box on the form.

 

[Guest]

As to your currency issue, use the Format property of the text box. Put your
cursor in the format box and one of the options is currency.
As to updating the in stock quantity. That will depend on a couple of
things. If the in stock quantity is in the table or query bound to your
form, the it will be pretty straight forward. You could put an invisible
control on your form that would be bound to the in stock quantity field.
Then all that would be necessary would be to put code in the Before Update
event of the form to subtract the quantity ordered from the instock quantity
and change that value in the in stock text box.

Me.txtInStock = Me.txtInStock - Me.txtOrderQuantity

If it is in a different table, then you would need to construct an update
query that would do the same thing.

 

[Guest]

the text boxes did not change format when i select currency, i have them set
up to where when i select from the drop down menu i have Me.textbox1 =
Me.Combo59.Column(3), then if i set the text box to have the control of the
sale price in the table it changes it to currency but then when i select
something from the drop down all the text boxes change instead of just the
one in front of the drop box im using. what i want is one drop to select a
type of product then it requeries the next drop box to show the different
items under that product and then when you select that it displays the price.
then you select the quantity and in doing so it automatically subtracts that
value from the table with the in stock column and saves it that way. it need
it to do all on one page ten seperate times to select up to ten different
items. then at the bottom i need to add up to get a subtotal then multiply
by 0.065 to get the tax and then add the tax and subtotal to get a grand
total. this is all i need to do someone help me with this.