Results 1 to 2 of 2
  1. #1
    astralplaydoh is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    1

    Quantity Field determines how many of another field show up

    I am editting an inventory database I made awhile ago. I have a form for receiving shipments. The form has a section for quantity. It defaults to 1. I also have a field to enter the tracking number found on the package. If someone changes the number of quantity, I would like it to add additional fields for that amount of tracking numbers. Any ideas?

    Would I need to make additional fields for the tracking numbers. TrackingNumber1; TrackingNumber2; etc...?



    How would I handle the form growing/shrinking depending on the number of fields needed?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like they should really be additional records, not additional fields.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report won't show added field
    By Jojojo in forum Reports
    Replies: 0
    Last Post: 11-12-2011, 01:14 PM
  2. Combobox to show two field values
    By lnordstrom in forum Forms
    Replies: 2
    Last Post: 03-30-2011, 12:33 PM
  3. New Field Will Not Show Up in Form
    By batowl in forum Forms
    Replies: 9
    Last Post: 12-16-2010, 11:34 PM
  4. Data won't show up in table field
    By texzen123 in forum Forms
    Replies: 3
    Last Post: 11-26-2009, 11:20 AM
  5. Return blank field depending on quantity
    By anthonyjf in forum Access
    Replies: 1
    Last Post: 04-01-2009, 08:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums