using a query to add records to subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an order form with a subform for the order line items.

I have a second subform that has all items we've ever ordered from the
supplier of the current order. (linked by supplier) I have a place to put
order quantities in this listing.

I'm trying to run an update query that will move these records to the line
items of the current order. My problem is, that it will add the selected
items to all orders for that particular supplier, not just the current one.

Is there a way to run a query inside a form, but to limit it to the current
record only?

Thanks for the help!
Bianca
 
Not a problem. I would suggest a command button where you would run your
update query in the Click event. Filter your query on the primary key of the
current record.
 
Back
Top