Filtering Null Values 1

[pgfe]

Hi,

I hope someone may be able to point me in the right direction.

I have db with various tables, one holding address details.

From this table I have created a form to list records from that table, on the form I have three combo boxes, cboCountry, cboCounty and cboPCode which I use to filter required Country, County and Post Code records.

I do this by using DoCmd.Applyfilter, I am however finding it difficult to find a way to filter any records where one of these fields is null.

Any help would be greatly appreciated.

Regards

Paul

 

[Remou]

So how are you coding the filter?

 

[Zion7]

Me.filter = "txtPCode Is Null"

Me.filter = "txtPCode & '' = ''"

Me.filterOn = true
???

 

[Remou]

I do not think that the field in your table is called txtPcode.

Try:
Me.Filter = "Trim([Name of Field] & "" "") = """""

 

[Remou]

Sorry Zion7, I thought your post was a reply from the OP

 

[Zion7]

No worries Remou,
my brief response i'm sure, made it look that way.

Paul, more specifically

DoCmd.ApplyFilter , "txtCountry= '" & cboCountry & "'" & _
" AND txtCountry & '' <> ''"

 

[pgfe]

Hi Remou & Zion7,

Many thanks to you both that little problem is now resolved and it's fair to say that all the threads were helpful, they made me think about how I deal with another couple of issues. Sometimes you get bogged down trying to be clever when simplicity is the way forward.

Once again many thanks.

Paul