An Issue with a Combo Box Filter

[cross5900]

I am having an issue with my combo box filter, this set of code dynamically updates the combo box to add any new user and select the accounts that are assigned to them. Given everything works and everything filters, the problem is merely a cosmetic one that has to be fixed.

Basically what is happening is the Combo Box displays "*", and "All Records" but we can not get it too show the "Unassigned" -- any idea why?

Thanks.


AllAssigned: Select Query

SELECT DISTINCT Tbl_Information.AssignedTo, Users.UserName
FROM Tbl_Information INNER JOIN Users ON Tbl_Information.AssignedTo = Users.UserID;

Filter_uQry (Union Query)

SELECT "*" as UserID, "All Records" as UserName FROM AllAssigned

UNION SELECT "","Unassigned" FROM AllAssigned

UNION SELECT AllAssigned.* FROM AllAssigned;

Record Source on my Form

SELECT InformationNoComments_qry.* FROM InformationNoComments_qry WHERE (((nz([InformationNoComments_qry].[AssignedTo],"")) Like [Forms]![SOC Aged]![FilterBox] Or (nz([InformationNoComments_qry].[AssignedTo],""))=nz([Forms]![SOC Aged]![FilterBox],"")));

Row Source for my Combo Box

SELECT nz([Filter_uQry].[UserID],"") AS UserID, Filter_uQry.UserName FROM Filter_uQry;

 

[cross5900]

No one has an answer for this one?