Results 1 to 4 of 4
  1. #1
    a4kitchens is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    2

    Problem autofilling multiple product details on sales form

    Hi There,
    Im currently trying to develope a database to help a small family run business to better run their company, they are friends so trying to give them a hand. I only have a fairly basic knowledge of Access and have been picking stuff up as I go along.



    Basically have the majority of the database sorted but the main issue I am having is with the productsales form. Ideally I would like to be able to input the productID and have it populate 2 boxes (yet to be created) with the model number and sale price from the products table.

    There are a few other bits and piecies I would want to do, mainly creating a couple total boxes at the bottom and have the customerid auto fill a customer name and address field.

    Any help would be great.
    Thanks
    Tom

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    You could try putting your Product ID text box on one Form and putting code behind a Command Button on that form to open another Form that has all the other data from your Products table.

    You can look here for an example of how to do this:
    http://www.baldyweb.com/wherecondition.htm

    Feel free to ask any questions you may have.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Underlying table structure is key to an efficient and easily maintained data base application. Spend time with design to get the structures set up; and create some sample scenarios to test your model.
    Here's an existing model that may have some things you can use.
    http://www.databaseanswers.org/data_...ries/index.htm

    Here's another link that you should be familiar with
    http://www.google.com/url?sa=t&rct=j...ALCxrwTsf-BHwA

  4. #4
    a4kitchens is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    2

    database attached

    Had a lot of trouble uploading yesterday but hopefully this will help everyone understand what I was trying to explain

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

Similar Threads

  1. Replies: 5
    Last Post: 06-30-2011, 02:24 AM
  2. Form details not printing
    By Ashe in forum Forms
    Replies: 0
    Last Post: 03-08-2011, 12:27 PM
  3. Multiple Details Sections of report
    By nkuebelbeck in forum Reports
    Replies: 1
    Last Post: 03-17-2010, 09:34 AM
  4. Replies: 0
    Last Post: 12-14-2009, 09:57 PM
  5. Replies: 0
    Last Post: 11-23-2009, 09:19 PM

Tags for this Thread

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