can't show records in the listbox

[ahau]

Hi,

I was wondering if anyone might be able to help me here.

In a table, i have the following data.

ID ProjectName NA_ID NA_Site_ID
1 Team30 3000
2 Microscope Team31 3000

Then, in a form, i have a listbox that displays everything from the table on the top. I also have 3 combo boxes on top of the listbox to enable user to do searching. They can search by ProjectName or NA_ID or NA_Site_ID. However, my trouble is i can't get the first record to be shown in the listbox because the project name is empty when it's actually in the table.

Is there a way of getting around this problem apart from putting a dummy name as a project name?

Thank you very much

 

[formerTexan]

Rather than entering dummy information, you can start in the right direction by amending the Listbox's rowsource parameters to include null values as in the following example.

WHERE (((Table.ProjectName)=[Forms]![FormName]![comboName])) OR (((Table.ProjectName) Is Null));

Cheers,
Bill