Return records with empty combobox value

[vincentsp]

Hi all,



In my table I have a total of 6 fields, 2 of the 6 fields get there value using a combobox based on another table.
In total some records have a values in both the comboxes other records in just one.

In my query I would like to ad extra fields from the tables which the comboboxes are based on.

The problem I have is that once I ad the fields in my query it only shows me the records where both of the comboboxes have a value.
Is there a way to show all the records including the records where only 1 of the 2 comboboxes has a value.

I hope this makes sence, if not I'm happy to post an example database.

[pbaldy]

Is this appropriate?

http://access.mvps.org/access/queries/qry0001.htm

[ssanfu]

In my table I have a total of 6 fields, 2 of the 6 fields get there value using a combobox based on another table.

This tells me that you have lookup fields in the table. This is considered to be "bad" (as in "Evil"). See http://access.mvps.org/access/lookupfields.htm
(also see: http://access.mvps.org/access/tencommandments.htm)

I never use lookup fields in tables.