Lotus notes linked table and Select "all" in combo box

[olibh]

I have successfully added "all" to a combo box using a union query with access 2000 i.e SELECT "*" FROM EMPLOYEES UNION (SELECT [LASTNAME] FROM EMPLOYEES;

Then I can select from a query using the Like "*" operator. This all works fine within access but when I try to do the same on a linked notes database I get the following error

ODBC--call failed.
[Lotus][ODBC Lotus Notes]Data type mismatch of corresponding columns in UNION operation.

Does anyone know a way around this - I am using rowsource Table/query to generate the results.

I have several combo boxes an need to be able to drill down depending on the results of the provious combo box results.

I really need to be able to select all!!!

Any help would be greatly appreciated as my head is on the block with this one.