ComboBox without duplicates (1 Viewer)

[Blancorn]

Hello everyone,

I would like to ask your for a hint regarding my form.

I have a form with two fields only (task, employee). In this form I can assign an employee to the task.
With few rows it is not difficult, but when we have more employees it is not so easy.

Is it possible to set ComboBox in the way that:
as soon as an employee is assigned to another task (is selected in one row), it is not shown on the drop down list for another function (another row)?

 

[MajP]

I demo this in the above thread. Limiting the list to unselected items is easy. You use as NOT IN subquery. The hard part is making this work in a continuous form. See discussion

 

[Blancorn]

unfortunatelly I need to do it in continuous form... can you please write here a link to the discussion you mentioned?

 

[MajP]

Sorry, that was a bad link. The example is continuous and there are several possible ways to handle it.

Semi Unique Combox Record Source on Continuous Form

Take a look at the demo on the right. This uses the trick of overlaying a textbox on the combobox. This gets rid of fields going blank. In the current format if you key down it goes blank as well as the scroll

www.access-programmers.co.uk