Assign Records to Another Table from Subform

[justice2003]

I have two tables.
The main table contains a bunch of orders that different reps will need to work on. These orders will be assigned to the reps from a supervisor.

The main thing I would like to do is have a subform that displays all the orders in datasheet form. Then on the main form have a drop down of all the reps.
I want to be able to select multiple records on this subform and have a button to assign these selected records to the reps. Which these record numbers will be put in another table with the rep.

Is there an easy way to do this in vba? Or am I going about this the wrong way?

 

[dhookom]

I would abandon the subform in favor of a multi-select list box. You could then select one or more records in the list box and do something with them. I hope you don't have separate tables for each rep.

If you need more assistance, please reply with your table and field names as well as data types and primary/foreign key fields.

Duane
Hook'D on Access
MS Access MVP