Change color of combo-box text based on Query/Table comparison

[T_Tronix]

I have a table with all employees and I've create a query to find specific employees from that table based on a specific criteria.



Now I want to show a combo-box with all the employee names in it but the one that also appear in the query would show up in a different color.

I am assuming this should be written in VBA but I am unsure how to compare my table values to the query values....

[June7]

Do you mean you want the names in the dropdown list to be different colors?

I don't think that is at all possible.

[T_Tronix]

Do you mean you want the names in the dropdown list to be different colors?

I don't think that is at all possible.

So is there a way to make a button that changes the combo-box data feed? Like lets say I display record in the combo-box derived from Query1 but when I press the button I want it to display record from Query2...

[orange]

Might be easier for the reader to understand your issue if you posted the query sql. Or told us more about your Employee table and the criteria you are dealing with.
Sometimes just telling us WHAT you are trying to accomplish, in plain English, will get some advice and comments.

[T_Tronix]

I have the following tables:

Employees
Tasks

A query to find which of the Employees is available for a new task:

SELECT Tasks.Resource_F, Tasks.Resource_L, Tasks.Resource_ACF2ID
FROM Tasks, CachedDates
WHERE (((Tasks.End_Date) Not Between [CachedDates].[SDate] And [CachedDates].[EDate])) OR (((Tasks.Start_Date) Not Between [CachedDates].[SDate] And [CachedDates].[EDate]));

Now I've created a combo-box that allows to choose an available Employee based on the query result. But what if the person wants to see the full list of employees in that combo-box rather then only the ones available?

[orange]

So Employees are assigned to Tasks?
Many Employees, many Tasks ====> Many to Many relationship

see http://www.youtube.com/watch?v=7XstSSyG8fw

[T_Tronix]

Yes, there could be an employee working on several tasks and also a task worked on by several employees.

[orange]

Do you have a data model? If so, could you post a copy?

[June7]

I don't see how that query shows all available employees. To find all available employees requires a query that has both Employees and Tasks tables.

Can change the combobox RowSource in some event. The trick is figuring out the event(s). It's nice to use event(s) that will do this automatically and not burden the user with another click. Sometimes need more than one event to accomplish that. Could be the AfterUpdate event of textboxes for date entry. And/Or form Current event. For a new record certainly need full list of employees. Once dates are entered, want restricted list.

If Not IsNull(Me.SDate) Or Not IsNull(Me.EDate) Then
Me.Combobox.RowSource = "SELECT this SQL"
Else
Me.Combobox.RowSource = "SELECT other SQL"
End If
Me.Combobox.Requery