Results 1 to 2 of 2
  1. #1
    MaxQTime is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Location
    Kelowna, B.C.
    Posts
    42

    How to Open and Link Order form


    Hi Everyone. I'm trying to make a button that will open an order form with the customer ID already in and be able to add the order linked to that customer. So I have a table with customer info, and a table for the order information, including a linked field for the Customer ID. I have a form with a search box and a list of customers from that search box, i also have a button that will open up a customer form and let you edit the customer info based on which customer is selected in the list box.

    So, I need a button that will open a new form and let the user enter the order information in, and save it linked to the customer selected in list box of the previous from.

    Also if there is a way to stop the buttons from throwing errors if i forget to select a customer in the list box that would be a huge help too.

    Thank you.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    It would be easier to have the order form as a subform on customer form.
    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. Button to open form and link IDs
    By dniezby in forum Programming
    Replies: 16
    Last Post: 03-24-2017, 03:19 PM
  2. Replies: 14
    Last Post: 05-13-2013, 12:53 PM
  3. Open a form based on a link in Subreport
    By RapidRepairArnold in forum Reports
    Replies: 6
    Last Post: 12-20-2012, 03:55 PM
  4. Open Form and Link To Specific Record
    By burrina in forum Forms
    Replies: 2
    Last Post: 12-17-2012, 11:09 PM
  5. Replies: 4
    Last Post: 12-14-2012, 03:42 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