Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenation problem (Access 2000)

    I have a very useful popup form with ten text boxes.

    In the control source of the first text box i have the following :

    =[grade] & " : " & [ branch0] & "" & IIf([size]<19;" cartons ";" drums ")


    In the control source of the second text box i have the following:

    =[grade] & " : " & [ branch1] & "" & IIf([size]<19;" cartons ";" drums ")

    In the control source of the third text box i have the following:
    =[grade] & " : " & [ branch1] & "" & IIf([size]<19;" cartons ";" drums ")

    etx. etc.

    The above code is working for all the nine cases except the first, when i have branch0.In this case i receive the error "Name?"
    Obvisouly it is the 0 in the first case that is the problem. If i cannot find a way to improve my code, then it will work for all the nine branches
    except the first,but i would like to improve also the first case which has branch = 0. Is it possible to correct it at all ?

    The above popup form helps me to show the current available quantity of each product being chosen to issue an order.Depending on the size
    of the product it is written drums or cartons.I recommend it to everybody that has an order form. But you should avoid the 0,as in my case.
    I will be grateful to anybody that might help me solve my little problem.

    P.S. grade means name of the product, for example Cherry,apple, etc

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Concatenation problem (Access 2000)

    Is there a control or field called branch0? If not what is it supposed to refer to. Is the control the same name as a field? That will always confuse access. Is the name branch0 (using a zero) in both places or is one of them branchO. (using a capital o).

    If none of this helps let us know.
    David Grugeon
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •