Hi,
I have a form called assignment,this form contains 4 unbound controls:
agent (combobox),sort(combobox),cases,language(combobox).
I want to use this form to assign a certain number of cases to the agent
selected in the agent combobox..
I want to put a certain number in the control "cases" so when i run the
update query i may be able to control the number of cases assigned to each
agent.
Olduke - 13 Jan 2008 03:41 GMT
Pietro:
It would probably be a lot easier if you did this function the other way
around.
Create a form or report that shows how many assignments each agent is
currently working on and assign it using that.
Just a thought.
> Hi,
> I have a form called assignment,this form contains 4 unbound controls:
[quoted text clipped - 4 lines]
> update query i may be able to control the number of cases assigned to each
> agent.