Search results

  1. L

    handling zero values

    I have a text boxes that is updated based on a selection from a combo box. It updates several text boxes that contain prices, and some times that value is "$0.00." when i update that text box it doesn't put a value it in. It does if the value is anything but zero. I put the default value to zero...
  2. L

    updating a text box

    i think that there is something wrong with my combo box i have the data to fill the combo box coming from a query that lists all of the data that i want on the form. When I click on the drop down button for the combo box there isn't formatting on anything. Like currency appears like 3.75...
  3. L

    updating a text box

    Here is what my code looks like? Is it possible that my data from the combo box is screwing it up? Private Sub Combo57_AfterUpdate() [Original Price] = Combo57.Column(1) --these are supposed to be the same value [Material Surcharge] = Combo57.Column(1) --these are supposed to be the same...
  4. L

    updating a text box

    i use the after update of the combo box that is being selected. both of the values are currency.
  5. L

    updating a text box

    I have a text boxes that is updated based on a selection from a combo box. It updates several text boxes that contain prices, and some times that value is "$0.00." when i update that text box it doesn't put a value it in. It does if the value is anything but zero. I put the default value to...
  6. L

    Whats wrong with my if statement

    no its code
  7. L

    Whats wrong with my if statement

    I believe that you can use it with only one parameter.
  8. L

    Whats wrong with my if statement

    iif(Combo57.Column(1)<>0, [Material Surcharge] = Combo57.Column(1)) it keeps giving me the error "Compiler error: expected: =" http://flickr.com/photos/14540614@N06/2605721246/ i am trying to say if combo box column 1 is not equal to zero make my text box material surcharge equal to it...
Back
Top Bottom