Results 1 to 4 of 4
  1. #1
    Calucho51 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    2

    Enter several infomation

    hello
    I try to create a form to enter several goal values for each brand since each band have you own chain for the brand

    brand tequila Cuervo Goals
    AAAA store XX.00
    BBBB store XX.00
    CCCC store XX.00
    DDDD store XX.00
    Total XXX.00

    but each rand have a different store all the brand are different.



    I really apricide you help to guide me to get this done


    Calos

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    What is the issue?

    Do you have a table of stores? What is data structure and table relationships?

    Use a combobox for user to select store.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Calucho51 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    2
    Hi June7:

    Hi June7:
    Sorry for my previous post Y was no clear what I want to dobut it is my Table information:
    Supplier, Brand Sub Brand, Party Name,
    Actual Nine Liter Cases, Actual Traditional Cases, Actual Standard Case
    Goal Actual Nine Liter Cases, Goal Actual Traditional Cases, Goal Actual StandardCases;

    I need to enter the goal Fields to update my table, but thisgoals depend of the brand or sub Brand
    Each one have you own Party Name; I want in the forma that display the Party namedepend of the brand or Sub brand


    Thank you for you help

    Carlos
    Attached Thumbnails Attached Thumbnails Capture.PNG  

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    You may be describing what is know as 'cascading combobox' but there appears to be a language barrier and I might not understand your requirement. Do some research on that topic and see if that is the path you need to follow.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-01-2017, 10:28 AM
  2. Replies: 3
    Last Post: 05-15-2017, 06:33 PM
  3. Tab on Enter
    By Dan Lee in forum Forms
    Replies: 13
    Last Post: 03-05-2017, 08:34 AM
  4. Field auto enter new line on enter event
    By Ruegen in forum Forms
    Replies: 3
    Last Post: 09-17-2013, 09:00 PM
  5. Replies: 5
    Last Post: 02-06-2011, 04:32 PM

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