Combo Box null problem

[anttu]

Hello!

Looks like a grate forum for access topics and thats exactly what I need now! I'm new to Access and are going grazy!!

I'm trying to add some functions to an excisting database that someone else has done.

The Form creates an report from an db containing a one per day status information from water and electrical meters. Filling in start and stop dates gives a nice report over all meters and their status.

Now I want to add a combo box so the user can select one meter or leaving it empty to get all meters. I can make it work when selecting one meter in the list, but leaving it empty shows none. Or selecting any don't help all of the meters shows up anyway.

I used the search engine on this forum and found similar problem, but couldn't figure it out. Tried many combinations of the IIF statement, but didn't help.

Please help me!!

/Anttu

 

[quest4]

Your combobox is doing exactly what is should do with Null. Null means nothing or blank, no data. What you need to do is add and ALL to the combobox list. Then check this out:
http://www.mvps.org/access/forms/frm0043.htm
It is another good reference site. hth.

 

[anttu]

OK, I've got it working now!! Finally!!
Wasn't (of course) that hard at last, but I'm totally new to Access and it takes some time to getting to understand how one should think when working with it.

I used your link to mvps.org and another question on this forum to sort it out exact the way I want it!

Tanx!

/Anttu

 

[quest4]

Your welcome, glad I could help. Don't worry, by the end of your second dbase, you will be a pro.

 

[roosn]

hi

i have used the this code to good effect, but when i add a join with another table under a filter criteria, the combo output returns all values (of the first table) with no "all" (null) selection.

how do i resolve this

many thanks in advance

roos