ComboBox list displays blank data entries - annoying!

[hunterw]

I have a table I'm using for ComboBox list entries. Each column has a varying amount of fields (rows) utilized for their specific list.

The ComboBox which uses the column with the greatest amount of fields in the table has no problems, but every other ComboBox displays blank data entries. Aside from making a separate table for every single ComboBox, is there any way to prevent the ComboBox's list from displaying all those blank, useless fields?

Thanks in advance!

 

[hunterw]

Got it.

In the Row Source field, include a WHERE clause. Here's an example of the syntax:


SELECT [CT & Optical Protocols].[CT Resolution] FROM [CT & Optical Protocols] WHERE [CT & Optical Protocols].[CT Resolution] Is Not Null;