Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009

    Unanswered: querying a highlighted recordset

    I am designing an order tracking database for a retail store. I have created a form where users can populate an "Incoming Shipment" from a table of outstanding orders.

    The form has two sub forms (both are datasheets). One of the sub forms lists all of the outstanding products on order. The second lists the products which are In the current "shipment". Currently users can double click a record in the "outstanding orders" sub form which runs an Append query to list that productID and quantity in the incoming shipment table. All of this is working well.

    however it would be very useful for users to be able highlight multiple records in the "outstanding products" datasheet and append all of those product IDs and Qtys to the incoming shipment table.

    Is it possible to reference a multiple highlighted or active records in a query?

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    I don't think you'll be able to select multiple records without a field in the data to hold the selection. A multi-select listbox would be an alternative.

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