Report not showing records

[jeremy0028]

I have the following table

InsuranceID(Pk)AutoNumber
Insurance Name

I also have the following table called tblproviderID

Provider(Lookup ComboBox)code
SELECT [tbladdprovider].[ProviderID], [tbladdprovider].[First Name]&"
"& [tbladdprovider].[Last Name]&" "& [tbladdprovider].[MI]&" "&
[tbladdprovider].[Degree] FROM [tbladdprovider];

Insurance Name(Lookup Combo Box)
SELECT [tblAddInsurance].[InsuranceID], [tblAddInsurance].[Insurance
Name] FROM [tblAddInsurance];


Pin#(Text)
Box24K(Text)
Group#(Text)

Frm Primary Insurance(Lookup ComboBox) Insurance Name, InsuranceID

Heres the problem i'm having when generate a report I select primary
insurance from IRI-people form
Provider, Pin

However if you take a look at the top portion where Its says provider,
insurance, pin#, Box24k
If i select Provider Insurance and enter pin # in text box everything
shows up on report

But If i select Provider Leave insurance blank and enter Pin# the
report only shows providers that are associated with insurance
selected.

I do i generate a report so that if insurance field is blank it will
apply Pin# to all Insurances not selected