Rob thanks for the reply and apologies for the delayed response,

The first combo box uses a union query against a 2 local tables, and the
second again uses a union query but returns two fields from a query against
a linked SQL table.

Row Source 1:

SELECT [QryLandlordUNION].[Append_field] FROM [QryLandlordUNION]

QryLandlordUnion:

SELECT [Append_field] from [TblAppendField] where [Append_Field] <>"none"

UNION select [RPTgrp] from [TblLandlordGrp];

The query Adds "All" to the list of Report Groups (RPTgrp) from the Landlord
group table which is a local Jet Table.

Row Source 2:

SELECT qryPriorityUnion.Code, qryPriorityUnion.DESN FROM qryPriorityUnion;

QryPriorityUnion

Select "ALL" as Code,  [Append_field] as DESN from [TblAppendField] where
[Append_Field] <>"none"

UNION SELECT dbo_cmpgencd.code_id, dbo_cmpgencd.desn

FROM dbo_cmpgencd

WHERE (((dbo_cmpgencd.category_id)="priority") AND
((dbo_cmpgencd.mod_id)="hsg"));

Again this adds an "All" row to the records returned from a linked SQL
table.

As I stated in the original post - the problem only occurs when the
selections from the Combos and text boxes return no rows, if this occurs
then the two combos with query based rowsources have a pick list but if any
thing is selected then that selection is not displayed.

Very Odd.

Thanks

Kevin