• Continuous forms (2000)

    Author
    Topic
    #452216

    I am working on an applicaiton similar to a Point of Sale. I am trying to use a continuous form to hold my sales items as it handles adding additional items nicely.

    In trying to calculate the extended price (quantity * price) I have a text box to hold the value, but not store it in the table.

    I am doing the calculation in the onTimer event. It works great for the first item. When I add a second item, however, the total disappears until my second contains enough info to calculate a value. Then it shows that value for ALL items on the form. Not a good thing.

    How can I fix this?

    Thanks!

    Viewing 0 reply threads
    Author
    Replies
    • #1115794

      Instead of calculating the extended price in code, do one of the following:

      – Place a text box on the form with control source =[Quantity]*[Price] substituting the correct names, of course.

      or

      – Calculate the extended price in a query and use the query as record source for the form.

    Viewing 0 reply threads
    Reply To: Continuous forms (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: