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.

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.

"Pietro" wrote:

> 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.