Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    3

    Question Unanswered: Update Query or SQL Statement or VBA

    MAIN = form attached to the table DELIVERIES.

    New Record is: LOCATION, INVOICE,TIME

    Sub forms on page filter to different routes based on location table.

    As orders build up for each location, each sub form fills with orders.

    When a route has enough orders, a driver is assigned to the route.

    I have a button in the sub form for each route. The button runs a requery to update the status of the order from ORDERED to IN ROUTE.

    Here's the question. How can I pick up DRIVER to be updated as well.


    The end result needs to be a report showing;

    DRIVER

    TIME LOCATION INVOICE
    TIME LOCATION INVOICE

    DRIVER

    TIME LOCATION INVOICE
    TIME LOCATION INVOICE
    Attached Thumbnails Attached Thumbnails DelvieryTrax.JPG  
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Moved to MS Access forum.
    George
    Home | Blog

Posting Permissions

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