Probably simple but I am searching for nil data in a value list

[RexesOperator]

I have an unbound combobox on an unbound form that I use to search for records by province. This is simply a value list that the user selects from. The result is then used by a query with frms!frmGetProvince!txtPROVINCE.

However not all entries have a province - ie the field is empty.

How do I get a value list to return the records with empty province fields?

 

[Alansidman]

Take a look at this.

http://www.datapigtechnologies.com/flashfiles/searchform.html

A little bit of VBA will take care of it.

Alan

 

[RexesOperator]

Yeah - I like their site. I have used their tutorials for a number of different things.
I came up with a quick kludge. I used an update query to change the empty fields to -- and added -- to the field list.