Hello, I have a database which several users here have been helping me with, and I would like help getting it to work.
In the database there if a form frmAssign which I would like to modify [Imported].[Assignment] based on user selections.
The goal is to select a user from the list box (drawing from tblUser) and pass [tblUser].[Username] to [Imported].[Assignment]. I would like the user to either be able to select a range of years (from [Imported].[Year]) or reference numbers (from [Imported].[Call Number]) and assign the selected user from the list box when he or she clicks cmdAssign.
I would also like to clear the assignments for a user when they click cmdRemoveAssignment.
If anyone can help me figure out how to do any of the above, I would very much appreciate the feedback.
Thanks in advance,
I have attached an example copy of this database to the question.