Assign Default Value

[TheViruz30]

See Attached database

I have a frm called frmaddprovider Main form see database
I Also i have subform called frmsubformproviderids with
2 command buttons Add Provider ID and Refresh data

When i generate a report by selecting insurance name, insurance id, from the table called tbladdinsurance and also select Provider, Pin from the table called tblproviderids

When i generate the report as you can see by the sample database only insurances that are selected in the combo box shows up

How do I assign a default value so if the insurance combo box in the subform field is left blank it will automatically assign the Pin# to all insurances and when i generate the report it will show all insurances along with provider and Pin#

 

[aleb]

I might be wrong ... but I think what you need is to change in the record source for your report the word INNER to RIGHT

 

[TheViruz30]

Re: reply

I changed it as you said

It shows up but still dosnt show the insurance

For example see where it says medicare i want the other insurances to show up also

 

[TheViruz30]

Re: Change Inner to right

I thought i change it to left to see what will happen
When i used this option it does show all insurances
however only shows the medicare Pin#
and not the Default Pin for the other insurance

Change the report record source from Inner to left and you will see what i mean

 

[aleb]

What do you mean a default pin# for the other insurances?
I looked in your tables there was nothing like "default"
If you just need to show on the report a word "default" whenever there is nothing in the Pin# field then
go to design of your report
Change the properties of pin# field
Name - txtpin#
row source - =iif(isnull([pin#]=true,"default",[pin#])

And of course LEFT join