Help assigning records with an update query

[brendandaly]

Hey there, I'm trying to design an update query that will allow admins to assign a number of records of their choosing for editing to one of a short list of users. 'User' is a drop down box taken from a table and there is an auto number giving each record an Id. If possible, I'd like to have it pop up with a box asking which user to assign records to, then one saying how many records to assign. I've been trying to figure this out for a while now and any help is really really appreciated. thanks!

 

[jzwp22]

Welcome to the forum!

This can be done with a combo box to identify the user, a multi-select list box that holds a list of the available things to assign and a button to run an append query (not an update query). But, it all depends on your table structure. Can you provide more info on your tables (table, fieldnames & relationships)?